Selection criteria for a query

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I have a query where I enter a begin and an end date for
the date field and it works fine. I can then add another
selection in the product category and limit it one more
time. I then try to add a second selection and it appears
to work one time, I save it and close it out, reopen it
and never works again.
Please help.
Thank you.
 
This may be a problem with data types.

If you are using parameters (where Access pops up little boxes and asks for
a value), declare them. Choose Parameters from the Query menu, and enter
them one per line, specifying the type for each one.

If that does not solve the problem, switch the saved query to SQL View (View
menu), and paste the SQL statement for someone to look at.
 
Back
Top