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.

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)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top