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

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
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top