Querying a range of dates

[cderow]

Hello,
I am in the midst of creating a simple Access 97 Database, and I need to know how to setup a query to find a specific range of dates. In this case, I want to include people between the dates of 6/1950 and 6/1960.

I've been trying to do this in the query design view by putting these dates in at the bottom where it says criteria in this manner: "6/1950-6/1960". Of coarse, nothing comes up under the query's columns. I really don't think I'm entering it the right way. Could someone please show me the correct way to get specific date ranges to show up?

 

[scriverb]

Copy and paste the following in the Criteria Row for your Date Field:

Between #6/1/1950# and #6/30/1960#

Post back if you have any problems or questions.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[cderow]

Will do. Thank you for your reply.