In running a query in Access it pops up the ? boxes twice. How do I fix that?

Question

Its a query for a date range on a specific name. But it runs thru the query twice for some reason.

Answer 1

which field are you running the parameter in. if the query needs the user input the date range and it was setup properly, the parameter window will open twice, once for the start date and once for the end date.

if the parameter is for something else like the name. Most likely its a problem with a link between 2 tables. Go into the query design and view the actual SQL code. make sure all the table names and field names are in brackets [ x ]. This should fix it. if not post the original SQL String.