Web Development

Ask something
Question Locked

Access queries to span multiple columns

0 helpful
1 reply

by jiminpa

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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'

1 reply

This discussion is closed to new replies.