Keith Clark wrote:
I would love to be able to run a report of sales I made yesterday but I
have no idea of how to do that in a query...preferably a GUI based
query.
Any help?
For a specific example see:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=5245
The thread shows the solution in both SQL and a nice screen shot of how
this looks in the GUI designer - simply replace the entry <=364, in the
criteria row, with 1 for yesterday.
For a list of the functions available in a standard Base database see:
http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures
On the wiki includes all the options for the datediff function,
including the known bug in versions of Oo.o < 2.4 ...hmmm... maybe the
was fixed in 2.3.1...don't rightly remember off the top of my
head...anyway, if you have an older version and you get the error
message (again there is a screen shot of the exact error message in the
forums post just create your query in GUI mode, then before you run
it, switch to SQL view, click on RUN SQL direct and save it.
Base your report on the query.
For other examples go to either the community forum or oooforum.org and
search for datediff.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
