Use a query to pull records for specified dates

[LChase]

Hey,
I'm not good with Access so of course I'm having a simple problem....I've created a query that only needs to extract records with a date between 7/10/2002 and 7/25/2002. I can't get it to run right. Either all records get pulled or none at all.
Can anyone help me on what the criteria should be?
Thanks!!!
LChase

 

[JANR]

In your criteria row for your datefield use this:

BETWEEN #7/25/2002# AND #7/10/2002#

JR

 

[LChase]

It still didn't work. Does it make a difference that the date field of the records is set as a date/time format?

 

[JANR]

It should work a normal simple Select query like this look's like this:

SELECT Somefield, SomeOtherField
FROM Table1
WHERE DateField = Between #7/25/2002# And #7/10/2002#

Perhaps you got some additional criteria which interfere with your query like Between ..... AND .... OR something else.

JR

 

[CMeads1975]

You could try:

>=07/10/02 and <07/25/02 where format is mm/dd/yy

Carl.

 

[LChase]

JANR and Carl,
Ok see this is why I have so much trouble with Access!! I found an error on my part. What a surprise, lol. I was putting my criteria under the wrong field so of course it wasn't pulling and dates up!
JANR - I copied your original reply to my problem and put it into the correct field, ran it and it works!! I'm so relieved and feel so stupid at the same time - ha ha!
Thank you both for your help!! I appreciate it very much!
LChase

 

[JANR]

No problem

JR