Criteria In Query Changes On Save

  • Thread starter Thread starter Mariann
  • Start date Start date
M

Mariann

I have noticed in Access 2002 that if I have multiple
lines in the criteria section of a query that Access will
change the layout of the criteria when I save and exit
the query. In the past it has not impacted the results
but today it happened again and is causing the results to
be wrong. Has anyone else seen this? Is this a normal
Access 2002 function or does it sound like a bug or bad
install? I had used Access '97 for years and never saw
anything like this happen.

Thanks,
Mariann
 
Access will rewrite queries to proper SQL format. However, you should get
the same result. If you are getting something unexpected, your query was
probably incorrect in the first place. Did you add another criteria? Based
on how Access changed your original query, you might have added the new
criteria incorrectly. You will need to describe your query more to find a
definitive problem.

Kelvin
 
Back
Top