On Thu, 2008-06-05 at 00:57 -0400, Drew Jensen wrote: > 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
Thanks for the links Drew, worked out perfect for me. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
