On Thursday 07 December 2006 12:45 am, LeRoy Tallada wrote: > I am trying to get info on how to do a query with a start and a > stop date. > > I am using Open Office 2.0.4 > > Any help would be great.
Here is an example of how I have done it: The start date is April 1, 2006, and the end date is October 31, 2006. (My locale uses MM DD, YYYY.) I enter all of the fields that I want to use in the query with the date field entered twice. The row of the query to consider is the Criterion. In the first date column enter >=#04/01/2006# in the Criterion row. In the same row, go to the second date column. Enter <=#10/31/2006#. When you run the query, the chosen fields will have entries listed from April 1, 2006 to October 31, 2006. This information may also be in Help. Make sure that you have the pound sign, #, before and after the date. Dan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
