Running the query returns all records

  • Thread starter Thread starter Diane
  • Start date Start date
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.
 
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)?
 
Back
Top