Query to Search Multiple Fields 1

[brandonrjordan]

I have a table where we scan out cable boxes and cable modems to our technicians in the morning. Each piece of equipment is stored in its own column. There is no ryhme or reason as to which equipment ends up in which columns. It's all random in which gets barcode scanned first. My question is how can I creat a query where it searchs each field with one search feature. Not 21 search features for the 21 different fields that I have for equipment. I saw a vague explanation earlier today but it explained everything in SQL and I don't know how to do that.

Another possible solution I heard of was using ONE field instead of 21 and make a form that can allow me to enter multiple pieces of equipment into the same field with the same transaction ID but the subforms don't make much sense. I spent $40.00 on a ACCESS handbook but it doesn't detail unusual circumstances like mine.

Help!!!

 

[PHV]

it explained everything in SQL and I don't know how to do that
How to do what ?
A starting point (SQL code ...)
SELECT ...
FROM ...
WHERE field1 & field2 & ... & field21 Like '*' & 'your search pattern here' & '*'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886