Hello:
I’m stuck on generating a report (also on query) for the database that I’m developing. However, a portion of the database table is as follows:

Table: Projects
ProjectID (PK)
NumberOfPositions
Status: (Boolean Value)
…..


[Sample Value of ProjectID is ADM305, EVP201……..]

Table: ProjectMajor
ProjectID (PK)
MajorID (PK)
[Sample Value of ProjectID ADM305, EVP201……..
Sample Value of MajorID Business Administration, Electrical Engineering…..]


Table: Majors
MajorID (PK)
CategoryID (FK)
[Sample Value of MajorID Business Administration, Electrical Engineering…..
CategoryID is BADM, HNRC……]

Table: MajorCategory
CategoryID (PK)
Category
[Sample value of CategoryID is BADM, HNRC……
Sample value of Category is Business Administration, Human Resource…….]

As you can see that table ProjectMajor resolves the M-M here and rest is straight forward. The report that I need to generate is as follows:

Business Admin. Computer Sc. Human Resource
Inactive EVP506CA DS11CA ADM200
EVP8CA

Active DS710CA DS505IP EVP37
ADM100IP EVP100
EVP300CA

I tried cross tab queries but later I found out that it is not the case because I don’t need to count or sum or something with the values of the project number. All I need is simply to display in the above format.
I am not very experienced developer so any help in this regard will highly be appreciated.
Thanks in advance,