A
ajenks
When I use MS Query to bring data from an external source, Query
usually translates my criteria into a HAVING statement, which results
in my criteria being included in the GROUP BY statement -- which I do
not want. I then have to manually change the HAVING to a WHERE, move
the criteria up above the GROUP BY and edit the GROUP BY.
I don't like to be bothered to do this, and have trouble explaining
this technique to others.
Is there a way to make MS Query default to WHERE instead of HAVING?
Is there a way to influence which method is used for a particulary
query?
Thank you.
usually translates my criteria into a HAVING statement, which results
in my criteria being included in the GROUP BY statement -- which I do
not want. I then have to manually change the HAVING to a WHERE, move
the criteria up above the GROUP BY and edit the GROUP BY.
I don't like to be bothered to do this, and have trouble explaining
this technique to others.
Is there a way to make MS Query default to WHERE instead of HAVING?
Is there a way to influence which method is used for a particulary
query?
Thank you.