Share via

Access Question re query filter

Anonymous
2024-10-07T21:41:41+00:00

I have Microsoft Access and imported an excel worksheet to Access. I opened the worksheet and I wanted to query design and I selected all the columns I needed. I used criteria to filter as I want to pull the cells that all have the letter B in parenthesis for example: (B) However everyone filter I use doesn't pull the cells that contain (B). Please help.

Microsoft 365 and Office | Access | For business | 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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2024-10-07T22:15:44+00:00

    probably because your criteria is:

    "(B)"

    This would only select records with that exact value, so not "abc(B)def".

    If you want the records where "(B)" is anywhere in the string, use:

    Like "*(B)*"

    Was this answer helpful?

    0 comments