Leading Asterisks

  • Thread starter Thread starter Michael D. McGill
  • Start date Start date
M

Michael D. McGill

I want to query a datasource but exlude fields that begin w/ an asterisk. So
if a last name was *Smith I would want to exclude it. What is the criteria
expression to exclude literal asterisks?

Thanks,
Mike
 
Michael

Have you tried surrounding the special character with square brackets? I
think Access HELP has something on this under "wildcard".

By the way, if you have a field that holds "*Smith", you may be violating
the "rule" about only keeping one fact in a field. If there's something
"special" about either the ?LastName (=Smith), or about the entire row, add
another field, make it a Yes/No, and "check" the special ones.
 
Back
Top