Wil Cards in Report Preview Command Where Condition

  • Thread starter Thread starter silva
  • Start date Start date
S

silva

I'd like to know if there is a way to use a wild card character in a report
preview command. This would be the instruction used with a command button:

DoCmd.OpenReport stDocName, acPreview, , "[field_name] = 'filter text' "

I have entries that vary at the beginning, but always have the same ending,
and I'd like to be able to filter accordingly. Would this work in this
fashion? Or am I going to have to screw around and make special case queries
just for these?
 
silva said:
I'd like to know if there is a way to use a wild card character in a
report
preview command. This would be the instruction used with a command button:

DoCmd.OpenReport stDocName, acPreview, , "[field_name] = 'filter text' "

I have entries that vary at the beginning, but always have the same
ending,
and I'd like to be able to filter accordingly. Would this work in this
fashion? Or am I going to have to screw around and make special case
queries
just for these?
Click to expand...


Check out the help topic on the Like operator. For example,

DoCmd.OpenReport stDocName, acPreview, , "[field_name] Like '*ending'"
 
Back
Top