Running the query returns all records

D

Diane

I put a parameter to prompt the criteria of a field called
(DateOut):
Between [Type the beginning date:] And [Type the ending
date:]
When I run the query and put in the dates, it still gives
me all the records.
 
J

John Vinson

I put a parameter to prompt the criteria of a field called
(DateOut):
Between [Type the beginning date:] And [Type the ending
date:]
When I run the query and put in the dates, it still gives
me all the records.
Click to expand...

Please open the Query in SQL view and post the entire SQL string here.
Is the field in fact a Date/Time field, or might it be "dates" stored
in a text field (which will be searched alphabetically, not
chronologically)?
 
Top