Dan, Thanks for responding to my request. I will try this but I don't think it will do what I am needing. What I am needing the program to accomplish is the query to prompt me to enter a starting and a ending date so I can search the database for specific records. If you or anyone out there knows more let me know. Thanks
> From: [EMAIL PROTECTED]> To: [email protected]> Subject: Re: [users] > Double Date Query> Date: Thu, 7 Dec 2006 15:35:14 -0600> CC: [EMAIL > PROTECTED]> > 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 _________________________________________________________________ Express yourself with gadgets on Windows Live Spaces http://discoverspaces.live.com?source=hmtag1&loc=us
