retrieve records from a table based on a portion of text

[JDwork]

I would like to retrieve records where the Field 2 item contains a "2:" in
it's text.

This should be simple, but it's been too long since I've done. Do I use
criteria or filter in Access?

 

[fredg]

I would like to retrieve records where the Field 2 item contains a "2:" in
it's text.

This should be simple, but it's been too long since I've done. Do I use
criteria or filter in Access?

[Field2] like "*2*"

 

[Allen Browne]

In the Criteria row of your query, enter:
Like "*2:*"

 

[JDwork]

Thanks fredg and Allen!!! Looks familiar. Will do.

-JDwork