Multiple Fields

[Guest]

I entered 4 fields(combo boxes) of the same employee list on a form. The
reason is that I need this form to act as a survey and rate each employee
accordingly, thus every employee will get the same rating that is on that
particular survey. It would allow multiple employees up to four to be
entered onto each survey. However, I can't get all of the employee fields
into one report. I can report each field according to each employee. I can
also detail each employee field, but I can't combine all the employees into
one report. I am stuck with 4 reports of information I would like to
combine. I have created 4 queries, but I still can't figure out how to
combine all of the information. How can I make a report that will include
all of the employees information?

 

[Rick B]

You would have to share your database structure. How are you storing the
information?

 

[Guest]

Each combobox for the 4 employees pulls from an employee entry table. Thus,
everytime an employee is entered, it is pulled down from the employees that
are input in a seperate form with the survey infromation. It is then stored
in its own column in the table (such as employee1, employee2, etc). The rest
of the survey questions consist of their own columns. It is a survey based
on driver performance. Each survey has questions regarding the performance
of the driver on a specific move.
For example: A survey is written up by a customer and then input into the
database. That one move may have several drivers up to 4 on it. When a
survey is filled out, there can be as many as 4 drivers on that order that
would each have that rating tied to their name. If I were to input a survey
and select Bob and Bill as the drivers and give the drivers a rating of "1,"
I would want Bob and Bill both to have a "1" on their record.