parameter

[janed]

i have a query which when run, produces two parameter boxes. if i don't enter values in both the boxes i get a blank report. however it may sometimes be the case that i will only know one of the values. is it possible to have a report if i enter one as a blank.

 

[saintsman]

Try using the wildcard '*' in your box and see if that helps.

 

[janed]

ok. i thought of that but i wasnt exactly sure where to put it. can you help at all?

 

[David R]

I think you're looking for "*" & [Parameter] & "*" (you may only need one of them, depending on your parameter structure).

HTH,
David R