Search entire table or query

M

maggie

Is there a way to write a parameter query that searchs all
the fields in a table or a query and returns all the
records that match?
 
J

John Spencer (MVP)

You can do this by applying the same criteria to every field in the query. You
have to do an "OR" query.

In SQL.

SELECT <YourListOfFields>
FROM TheTable
WHERE FieldA = [Find This] Or
FieldB = [Find This] Or
FeildC = [Find This]


If you are doing this in the query grid, you need to stair step the criteria to
get the or effect.

Field: FieldA FieldB FieldC
Criteria: [Find this]
Criteria: [Find this]
Criteria: [Find this]

As long as the parameter is identical from line to line, you will only have to
enter it one time. Note that the fields all have to be the same type; all text
or all dates or all numbers.
 
M

maggie

Yes! it worked using the stair step approach.
THANKS!!
-----Original Message-----
You can do this by applying the same criteria to every field in the query. You
have to do an "OR" query.

In SQL.

SELECT <YourListOfFields>
FROM TheTable
WHERE FieldA = [Find This] Or
FieldB = [Find This] Or
FeildC = [Find This]


If you are doing this in the query grid, you need to stair step the criteria to
get the or effect.

Field: FieldA FieldB FieldC
Criteria: [Find this]
Criteria: [Find this]
Criteria: [Find this]

As long as the parameter is identical from line to line, you will only have to
enter it one time. Note that the fields all have to be the same type; all text
or all dates or all numbers.
Is there a way to write a parameter query that searchs all
the fields in a table or a query and returns all the
records that match?
Click to expand...
.
Click to expand...
 
Top