how to set up group header as column header in a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have a monthly report based on a time sheet that looks like this:

Month - Jan 05
-----------------
Proj No. Proj Name Proj Dtls ------------- no. of hours
---------------- tot hrs
empl- 1 empl-2 empl-
----------------------------------------------------------------------------------------------
4315 Marina Tower1 6 3 8
17
4316 Palm Crescent 10 5 3
1
---------------------------------------------------------------------------------------------
tot hrs empl 16 8 11
35
====================================================

pls help how can i make the employee accross the report in columns instead
by rows
thanks
 
Create a query into this table.

Change it to a Crosstab query (Crosstab on Query menu.)

From your example, it looks like you need:
Group By [Proj No] as Row Heading
Group By [Proj Name] as Row Heading
Group By [Proj Dtls] as Row Heading
Group By [Empl] as Columm Heading
Sum [Hours] as the Value.
 
Back
Top