multiple search

  • Thread starter Thread starter joe
  • Start date Start date
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
 
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.
 
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...
 
Back
Top