Information in multiple fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that was created from an Excel file. It lists development
prospects, and has a field for 1st Manager, 2nd Manager, and 3rd Manager. My
boss would like me to use Access to create a report showing her the names of
all the prospects that she is responsible for, which will require finding her
name in any one of those manager fields, and synthesizing it all into one
output--for instance, she might be the 1st manager on the Smith file, but the
3rd manager on the Jones file, and she may not be responsible for the
Johnsons at all. I have created 3 separate queries, one for all the things
she is first manager of, one for things she is 2nd manager of, etc. How do I
get one list with her name in any of those three fields? Am I making sense?
 
In query design view, use more than one line of the "criteria" section. Each
line is an "OR" condition.
-1st Manager field: = "boss name" (on 1st Criteria line)
-2nd Manager field: = "boss name" (on 2nd Criteria line)
-3rd Manager field: = "boss name" (on 3rd criteria line)

Should give you all records where your boss name appears in any of the 3
fields.

HTH,
 
Back
Top