Criteria for Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field in my query with addressess (numeric and alpha characters
combined...ie 111 W Main Street). I would like to write a criteria for just
part of the field (select out all "Main Street" records). I tried the [] and
* commands but those did not work. The field is a text field.

Thanks!

Dan Hayden
 
Daniel:

Have you tried using the LIKE keyword? For example:

LIKE "*Main Street*"

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a field in my query with addressess (numeric and alpha characters
combined...ie 111 W Main Street). I would like to write a criteria for just
part of the field (select out all "Main Street" records). I tried the [] and
* commands but those did not work. The field is a text field.

Thanks!

Dan Hayden
 
Back
Top