how do you create a query to search for a specific word or number in multiple columns? Say I have 28 columns of data each with a word or number. I need the query to look through all the columns and return every instance (row) containing that word.
Novice
Windows 7 64bit 
Access 2007
how do you create a query to search for a specific word or number in multiple columns? Say I have 28 columns of data each with a word or number. I need the query to look through all the columns and return every instance (row) containing that word.
Moderator
Windows XP Access 2003
What have you done so far?
You could search for "Keyword search" "finding a word in multiple columns" or similar.
query to update columns based on values on other specific columns and values...
Query for specific month
Posting Permissions
Reply With Quote