Filtering using "contains"
I have a database table in Access 2003. I have a column that has data like this:
HC, IC, HP, PO
IC, PO, EM
IC,
EM, PO, WE
What I need to do is filter the table to show all records containing HC or PO or EM
HC, IC, HP, PO
IC, PO, EM
IC,
EM, PO, WE
What I need to do is filter the table to show all records containing HC or PO or EM
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
lol - umm I think you missed?
I was just passing the time of day - stood here leaning on the metaphorical lamppost.
Miriam's Q surely.
I was just passing the time of day - stood here leaning on the metaphorical lamppost.
Miriam's Q surely.
*Lol!*
Try using like:
me.filter = "[YourField] LIKE '*HC*' OR [YourField] LIKE '*PO*' Or [YourField] LIKE '*EM*'"
(replace YourField with the application specific name)