report with name appearing in any of 4 fields

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hi,
I would like to create a report that will show all records
that contain a particular name in ANY of 4 fields. Any
suggestions? Thanks.
 
Bob said:
I would like to create a report that will show all records
that contain a particular name in ANY of 4 fields.


Set the report's record source query to use a Where clause
like this:

SELECT f1,f2,f3,f4,. . .
FROM table
WHERE f1="name" OR f2="name" OR f2="name" OR f2="name"
 
Back
Top