Wil Cards in Report Preview Command Where Condition

[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?

 

[Dirk Goldgar]

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?

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

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