Using a Where Clause to Filter Data

**purpleangelbear** · 08-16-2018, 09:22 AM

Hi-

I'm somewhat a novice at Access. I've built buttons where Field x matches exactly Field y in two separate forms. How do I do a button where the data might not match exactly? I've played around with the Where Condition and I just can't figure out the correct format to use.

**ranman256** · 08-16-2018, 09:23 AM

sWhere = "[field] like '*" & txtBox & "*'"

Using a Where Clause to Filter Data

Thread Tools

Using a Where Clause to Filter Data

Similar Threads

Filter Report Data

If I filter data by In() I get only last day of month's data

Insert Value from subForm data and apply filter in the Mainform data fields

Find Record with a While Clause (filter)

Filter non-text data

Posting Permissions