Search across multiple fields in query

[rhomer]

I need to be able to search all the fields in a query, there are 9 fields, with a single parameter entry. Seems like there's a way but I can't find it. Thanks

 

[Jack Cowley]

Use a form to get the parameter and then use [Forms]![FormName]![FieldWithParameter] on successive Or criteria lines for each field. I assume you want to do and OR search rather than an AND search....

 

[KKilfoil]

Normalization Nag:

If you have similar data in 9 fields in a single table, you might have an easier time with your queries, forms, reports, and searches if you create a 1:many relationship to a new related table to hold these similar values.

If your data is NOT similar (but then why search all at once?), my aplogies.

 

[Pat Hartman]

Boy am I glad I'm not the only normalization nag here

It was all I could do to stop myself from making the same comment last night. Sometimes I feel sooooo alone.