Formula Field

I have a table in Access with fields as follows:

EmpCode
Month_Year
Percentage of Availability (PA)

I have another table called StaffMaster which has the following fields:

EmpCode
EmpName
Dept

In the report, I wish to retrieve and display records as follows:

Month1 Month2 Month3 Month4

EmpCode EmpName PA PA2 PA3 PA4

Can this be accomplished? I have a vague idea that it can be done using formula fields, don't know. Please help. Urgent!

Thanks

What you are describing is a "Cross Tab" report. The help file explains how to create these reports.

I saw that in the help file. But I don't know how it can be done. If you could help me please...

Thanks