View Full Version : parameter


janed
02-26-2002, 05:08 AM
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
02-26-2002, 05:26 AM
Try using the wildcard '*' in your box and see if that helps.

janed
02-26-2002, 05:30 AM
ok. i thought of that but i wasnt exactly sure where to put it. can you help at all?

David R
02-26-2002, 03:29 PM
I think you're looking for "*" & [Parameter] & "*" (you may only need one of them, depending on your parameter structure).

HTH,
David R