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

B

Buffy

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

Brendan Reynolds

Try ...

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

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