rhomer
03-14-2002, 02:04 PM
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
|
View Full Version : Search across multiple fields in query rhomer 03-14-2002, 02:04 PM 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 03-14-2002, 03:09 PM 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 03-15-2002, 05:26 AM 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 03-15-2002, 10:03 AM Boy am I glad I'm not the only normalization nag here http://www.access-programmers.co.uk/ubb/smile.gif It was all I could do to stop myself from making the same comment last night. Sometimes I feel sooooo alone. |