Why would a between and And operator not work in a query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm probably being dumb but I've put this in as a criteria on a query,
Between [enter date] And [enter date] Unfortunately it only asks for the
first prompt and not the last so I only get results if they are the same date
as the first prompt. What on earth am I doing wrong?
 
Try ...

Between [Enter First Date] And [Enter Second Date]

.... the two parameters have to be different, otherwise they are regarded as
one parameter.
 

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

Similar Threads

Difference between fields in query 1
Duplicate prompts in crosstab query and subsequent report 1
Crosstab Query based on Query 4
Query Parameter - Between and and operator 1
Parameter query issue in Access 2003 6
Using Between Dates in a Query 4
show criteria data from a query on a report using that query 2
parameter query 2

Back
Top