multiple search

J

joe

hi there i need some help. i have four fields on table
tool_primeinfo that i need to search to.
how could i do this search? any help would be appreciated



subtooljoint
subjoint1
subjoint2
subjoint3

thanks again
joe
 
J

John Spencer (MVP)

Well, the best way would be to restructure your data so you didn't have
repeating fields but had a separate table. But since this seems to be a basic
question, you probably don't know how to do that at this point. And you haven't
posted enough information for me to give you specifics.

SELECT *
FROM YourTable
WHERE subToolJoint = [Find What] OR
subJoint1 = [Find What] OR
subJoint2 = [Find What] OR
subJoint3 = [Find What]

When you run this query, you will be asked one time to enter a value for [Find What]

In the query grid, you would need to put the criteria under each of the fields
and on separate criteria lines. So you would end up with a stairstep pattern for
the criteria.
 
J

joe

thank you very much for the help.
-----Original Message-----
Well, the best way would be to restructure your data so you didn't have
repeating fields but had a separate table. But since this seems to be a basic
question, you probably don't know how to do that at this point. And you haven't
posted enough information for me to give you specifics.

SELECT *
FROM YourTable
WHERE subToolJoint = [Find What] OR
subJoint1 = [Find What] OR
subJoint2 = [Find What] OR
subJoint3 = [Find What]

When you run this query, you will be asked one time to enter a value for [Find What]

In the query grid, you would need to put the criteria under each of the fields
and on separate criteria lines. So you would end up with a stairstep pattern for
the criteria.

hi there i need some help. i have four fields on table
tool_primeinfo that i need to search to.
how could i do this search? any help would be appreciated

subtooljoint
subjoint1
subjoint2
subjoint3

thanks again
joe
Click to expand...
.
Click to expand...
 
Top