Date range not working

[victoria61485]

Hello,

I am trying to run a query based on a table that has a date field. I want to run the query by a date range. I have entered Between #1/1/2011# And #6/30/2011# and Between [Enter Start Date] And [Enter End Date], then using the above date range, into the criteria of the query and I get all dates in the database, from 1/1/2007 to 09/03/2011. Is there something that would make the date range be ignored by Access?



Thank you for your help!

[rpeare]

Is your date field being stored as text or date/time.

If it's being stored as a date and you are hard coding

Between #firstdate# and #seconddate# and you are getting incorrect results

[victoria61485]

I think that I found the problem. In another field I have a criteria that includes an OR statement. I want that date range and this or that in another field. This seems to confuse Access and I will break this into two different queries.

[cap.zadi]

hey man,

just try this way, may can be helpful for u.

I have used something like this very recently. so i thght this might help you out. Design a form with a couple of text boxes.. for Start date and End date. Then put the following code in the control sources for each of them:

=[Forms]![yourFormName].[txtStartDate]
=[Forms]![yourFormName].[txtEndDate]

When user wants to see reports for other days as well, this will let you give the start date and end date. Make sure you give the same code for the date range in the query criteria that fetches your data. And like Paul already said, you could default them to Date(), so when you dont specify a date range, it returns "today" like you want it to.

regards
zee

[rpeare]

You shouldn't have to create 2 queries to do it.

What do you want your query to show and what fields are involved in your criteria selection?