Query Criteria - Making them stay on one line

[Emma Hope]

All,

This might seem a wierd one but there is a reason behind it but it's work
polictics and i won't bore you with it.

I have a query with 3 fields and the following criteria:

Customer Code Comment
<>"XYZ" <>"204" Like "*g4*" or (Like "*med*" and Like
"*pres*")

When i save and close and go back in it is now:

Customer Code Comment
<>"XYZ" <>"204" Like "*g4*"
<> "XYZ" <>"204" Like "*med*" and Like "*pres*"

I completely understand why it does this but i don't want it to, i want it
all to stay on one line in the Criteria section.

Is there a setting or any other way to make it stay put!

Thanks
Emma

 

[Marshall Barton]

This might seem a wierd one but there is a reason behind it but it's work
polictics and i won't bore you with it.

I have a query with 3 fields and the following criteria:

Customer Code Comment
<>"XYZ" <>"204" Like "*g4*" or (Like "*med*" and Like
"*pres*")

When i save and close and go back in it is now:

Customer Code Comment
<>"XYZ" <>"204" Like "*g4*"
<> "XYZ" <>"204" Like "*med*" and Like "*pres*"

I completely understand why it does this but i don't want it to, i want it
all to stay on one line in the Criteria section.

Is there a setting or any other way to make it stay put!

No. The query designer has its own way of looking at things
and will rearrange all kinds of things to make them more
obscure.

If your politics could decree that all queries can only be
looked at in SQL view, you could probably stop most of that.

If you want to see what I think is a really strange
transmogrification of your criteria, just add an outer set
of parenthesis around the whole criteria.