Query with varying number of parameters

[databasedonr]

Greetings,

I am trying to write a parameter query ... I have multiple fields the users *could* search, but they may want to search only one, and I am having a struggle figuring this out.

Ex. fields to search are Gender, Age, Date, etc., and I have created a parameter query that includes parameters for each of these fields. However, if I want to see all the females, thus leaving the other two parameters blank, I have no records in my result set. Clearly, I am doing something wrong -- I have searched the forum extensively before posting.

Thanks in advance, I am sure I am being simple and missing somethign....

 

[EMP]

Take a look at Jon's sample in this thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=103312

^

 

[databasedonr]

Thanks!

EMP, and to Jon by proxy -- that worked a treat. I am sorry I missed Jon's example in my searches, this is exactly what I needed. As usual, my indebtedness to the forum grows. Thanks ever so much.