Web Development

Question

Locked

Access queries to span multiple columns

By jimmy-jam ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums