SteveBlevins
asked on
How to filter for multiple criteria
How do I filter for multiple criteria in Access 2007? If you right click on a column, select text filter, how can you filter for multiple criteria? For example, I want to search for LastName = 'Jones' or LastName = 'Smith'.
Entering Smith works; entering 'Jones' or 'Smith' doesn't. This did work in Access 2003.
Entering Smith works; entering 'Jones' or 'Smith' doesn't. This did work in Access 2003.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Jinesh Kamdar
Can u post a snap-shot of ur Query Design view?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.