Share via

Filter fields containing a word

Anonymous
2018-04-23T06:49:16+00:00

Hello,

I have a table in Access in with i wish to filter only the records containing a certain word, for example "per".

How can i do?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Duane Hookom 26,825 Reputation points Volunteer Moderator
    2018-04-23T12:04:11+00:00

    If you want the entire field to equal “per” the your query criteria would be
    =“per”
    If you want any part of the field such as “add 10 drops per cup” then use like with wildcards:
    Like “*per*”

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-04-23T07:00:59+00:00

    You can use following as the criterion with equal to

    *per*

    Or you can use use contain criteria with per

    Was this answer helpful?

    0 comments