Rows as Column in Report (1 Viewer)

[Muaz]

Hi;

When I make a query to collect the data it looks like:
Staff No. Basic Salary House Rent Overtime Medical

But in report I want something like below i .e

Description Employee 1 Employee2 Employee3 and so on
Staff No.
Basic Salary
House Rent
Overtime
Medical

Is it possible in Access ?


Regards
Muaz

 

[pr2-eugin]

Look at CrossTab Query ! Think that is what you are after.