Query across several columns

[Guest]

I am trying to run a query that searches for the same keyword across several
columns. I have created a form which lists all of the searchable items in a
drop down list but at the moment it is only letting me search for the items
in one column. I want to search across several. Is this possible?

 

[Jeff Boyce]

Lucy

If the keyword you are searching for could be in any of multiple columns,
you probably are searching in a spreadsheet, not a well-normalized
relational database.

A well-normalized table would only have one field that contained keywords.

If you want to get the best use of Access' features/functions, your data
needs to be in the format Access is optimized to use.

If you need to keep the current structure, consider exporting to Excel and
doing your search there.

Regards

Jeff Boyce
Microsoft Office/Access MVP