Run Report with several options

[buckeye77]

In a nutshell...
Report "Advance"
I need to be able to run this report either by [FullName] and/or [Year] and/or [Month]. (would be nice if each of these could be a drop down - there are fields on the tables that hold this information)
Also, in the event one field is skiped in the selection, the report needs to pick up all in that field.
Thereby allowing someone to pick up all years and months for one person or they could view all the information for everyone for a specific year or month.
Is this where an Option group would help or do I need combo boxes for each field?

Any suggestions would be great!

 

[PHV]

I'd use 3 combos.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[buckeye77]

Okay... I have got a combo for each [FullName], [year], [month]. Now how do I write a code that will allow any mixture of the three?
I.E.
John Doe / 2008 / August
All / 2009 / September
Jane Doe / 2008
All / 2008
etc.....

From what I can find this would be done in the where clause, but how do write something like this....

I have not been able to find anything like this to look at..

Any suggestions as to where to start?

 

[PHV]

WHERE (fldFullName=cboFullName OR cboFullName Is Null)
AND (fldYear=cboYear OR cboYear Is Null)
AND (fldMonth=cboMonth OR cboMonth Is Null)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886