All Questions
Tagged with libreoffice-base query
3
questions
0
votes
1
answer
948
views
Subtracting two times in libre office base
How can I subtract two times in a query in libre office base? For instance, 10:30 - 9:00 should give 1:30. Thanks.
EDIT: As it says in the question, I am having this problem in "base", not with the ...
0
votes
1
answer
33
views
Query that needs input from two different records
I have a "timecard" table. A few typical entries might look like
ID task date start time
1 proj_XDFR 4/5/18 8:30
2 proj_PEIRN 4/5/18 9:45
3 proj_ERU54 ...
0
votes
2
answers
2k
views
Is it possible to put a wildcard search into a parameter query in LibreOffice Base?
I am using Base in LibreOffice 4.0 (still using the HSQL that comes with Base but looking at moving to HSQL 2.2.8) and I would like to do a query that asks for parameter input like:
SELECT * FROM "...