Hi CJ_London,
Thanks for the reply.
College 1 and College 2 are two fields that are in my Employee table. Actually all my fields are in just my Employee table.
Should I set it up the way you said it?
Because I'm currently using the sample "Faculty" template on Microsoft Access 2010, I'm...
I would like to make a report to show how many employees and which employees are attending to which colleges/universities.
In my data (800 records), I have two fields which is "College 1" and "College 2" for each employee.
There are values that are enter in college 1 for some employees...