Report Filter using "Like" not working?!

  • Thread starter Thread starter Bill Unger
  • Start date Start date
B

Bill Unger

I have this report filter in a report:

(AR1_CustomerMaster.URLAddress) Like '%bill%'

The record source for the report is a predefined query. If I run the report
with the filter, nothing is returned. If I copy the filter and paste it
into the query in SQL view, the correct data is returned - so I know it
works. The report is not doing anything other than selecting and displaying
data... any thoughts?

tia,
Bill
 
somewhere today I read that ADO uses %s as wildcards, while DAO uses *s. Do
you know for sure which you are using?

HTH
Dick Penny
 
Back
Top