Access queries to span multiple columns - TechRepublic
Question
August 5, 2008 at 07:35 AM
jiminpa

Access queries to span multiple columns

by jiminpa . Updated 17 years, 11 months ago

Before I write the code and beat my head against the wall trying to troubleshoot it if it doesn’t work… is it possible to write an access query that searches for a string in multiple columns for example.

SELECT * FROM table where COLUMN1 OR COLUMN2 OR COLUMN3 = ‘WHATEVER’

This discussion is locked

All Comments