"Between Date" Criteria for Query

[Boogamil]

My first post on this site, so please be gentle. I have looked through the previous posts and I haven't found what I needed.

It seems like a simple enough problem, but none the less I'm still having problems.

Under my criteria I enter my start date and my end date. If I enter in 3/1/04 to 3/5/04, I retrieve what I wanted, but also 3/10/04, 3/11/04, etc.

Any help would be greatly appreciated.

 

[Joe4]

Are your date fields actually saved in a date format, or in a text format? If they are saved in a text format, that would explain the results you are getting.

Also, when you are entering the criteria, are you entering the date surrounded by pound signs (i.e. #3/1/04#). That is how you tell Access you are entering a date as opposed to a number or text.

 

[bat17]

Can you post the SQL for us to look at?

Peter

 

[Boogamil]

The problem appears to be that the data type for the "Date" field was changed to text from date/time.

I appreciate your help, now I just have to work on protecting tables.

Thank you for your time.