multiple queries from a single form

I want to be able to execute specific queries based upon which fields in the form have data in them. Assume I have 3 fields - WR nbr, Topic, & date.

If I fill in a WR nbr & date I want to look up that WR for that date.
If I fill in a Topic & date, I want to look up that topic for that date.
If I fill in only a WR nbr, then I want to look up that WR nbr for all dates.
If I fill in only a date, I want to list all WR nbrs & topics for that date.

So, depending on the combination of data entered on the fom determines the query to be performed. How do I direct the proper query to be executed?

you could do an
if isnotnull(fieldname) AND isnotnull (fieldname)
run querynamedthis
else if isnotnull(fieldname) AND isnotnull (fieldname)
run queryname that
else etc

Try using one query. This might help: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=285

it writes the sql for your query based on your selections, you can then filter the fields afterwards.