Parameter for multiple columns

[cmclose]

Hi all,

I'm new to the forum and relatively new to Access. I've inherited a table with 8 Address columns, I am trying to design a query with a single parameter that searches all 8 of these columns, but can't figure it out.

Here's the current parameter that I'm using
Like "*" & [tables]![Branches]![AddressLine1] & "*"

it works great for returning records in the first column.

Please advise!
Thank-you so much.

Chris

 

[Rob.Mills]

You need to put that exact criteria in each of the columns that you want to search through. Don't copy it on the same line though. Put it on the first line for the first column, second line for the second column and so on.

 

[cmclose]

so thats what I was doing wrong, I have to move down a row for each column a move over... Thanks so much for the help, it works great!

 

[Rob.Mills]

Yep. When you put in on the same line it looks for records with that criteria in all columns. With it on different lines it looks for records with it in any one of the columns.