Query using "like" parameter

  • Thread starter Thread starter Porcha via AccessMonster.com
  • Start date Start date
P

Porcha via AccessMonster.com

I have a field that has 610 in it, but it may be a610 , or 555610 or yu610,
etc. How do I write a query that will return records that have any part of
610 in its field?

I tried ... like "610*" in my query but it doesn't return all.

thanks,
Porcha
 
I have a field that has 610 in it, but it may be a610 , or 555610 or yu610,
etc. How do I write a query that will return records that have any part of
610 in its field?

I tried ... like "610*" in my query but it doesn't return all.

thanks,
Porcha
Click to expand...

Like "*610*"

Or if you want to be able to change the value:
Like "*" & [What number?] & "*"
 
Back
Top