I am trying to use a wildcard, "*", in the filter property of a report and keep getting a syntax error or the filter just doesn't work. In my database I am searching a text field named Location for all locations starting with 99. Example of failed efforts:
Location='99?'
Location='99*'
Any help would be appreciated.

[This message has been edited by DSVB (edited 07-08-2001).]

Look up "Like" in Access help. That's what you need.

By the way, the wildcard character is *, not ?