query coding

Glad I could help.
--
Dave Hargis, Microsoft Access MVP


"hotrod1952 via AccessMonster.com" wrote:

I use this query to populate data for 2 (and possibly another yet to be
developed) forms. My query of the query idea did get me what I needed to make
this work. Thanks for your insight.


Klatuu wrote:
What is the query for?
With a stored query, it is a bit of work to modify a stored query on the
fly. Not hard, just a bit of code to get it right.

Now, if this is for a report, there is a better way. That would be to leave
the Having off the stored query and do the filtering using the Where argument
of the OpenReport method.
Stored query.

[quoted text clipped - 6 lines]
but not both and need an idea how to code the query to query for both 0 and 3.
Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1