I have two tables: One contains all the fields I need to create a report, except that I'm using an ID number for employees that are listed under 5 fields (A1, A2, A3, A4, A5).
The other table is my list of employees and their ID numbers. When I want to create a report, I want the name of the employee to show up in place of the ID number, so I created a query for each of the "A" fields. For instance qryA1 includes both of the above tables, but the ID number from the employee table is linked to the A1 field in the main table. When I look at the query as a table, it shows me the ID number and the person's name for all of the records that have an entry in the A1 field. The same thing happens with A2, etc. Then I created another query that contains the main table and all of the "A" queries. That is when I discoverd that it will only show me records where everything is equal. In other words, I must have (for instance) 4 employees in each of the "A" fields for at least two records in order to see anything. I know there must be a way to do this so I can see all of the records, including the ones where there is only an employee listed in A1, while the next record lists an employee in A1, A2, etc. I'm not sure this is very clear, but I'm trying! Thank you, Anne
