parameter query and show all 1

[emtenzer]

I am using a form for users to make their choices before running a report. I have two fields that I would like for them to be able to not choose anything so that the report runs for all of those options - for example, all transaction types instead of just one. I can do this when I only have one field - using "or is null" but I can't get it right for more than one field. Any help would be greatly appreciated.

 

[PWise]

where field1=iif(forms!.... is null,field1 ,forms!....)
and field2=iif(forms!.... is null,field2 ,forms!....)

 

[PHV]

where (field1=forms!.... or forms!.... is null)
and (field2=forms!.... or forms!.... is null)

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

 

[PHV]

Did you test what happens if either field1 or field2 is null ?