Input box in a report

racdata

Registered User.
Local time
Today, 07:25
Joined
Oct 30, 2002
Messages
74
Hi all
I am using a input box in a report (based on a querry) where I set the creteria as "Between [Date From] And [Date To]". Also in another field I Ask to Enter a [Department Code]. Then I can only get one department at a time. I need more than one but not all. The department codes is like M7258,M7288, M7253,M7278 etc.
Is there a way to use wild cards "?,*" in a input box?
 
Is your input box coming from a parameter query? You can use a wild card in parameter query criteria:

Like "*" & [Enter Department Code :] & "*"
 

Users who are viewing this thread

Back
Top Bottom