/working with MS ACCESS-2003

I have half a dozen projects handled by a
dozen people under the company heading.i
have a db which contains PrjID & PrjName
and also have a master table which stores
down daily time sheets of all the employees.


PROJECT
PRJID PRJNAMES-
1 PROJ1
2 PROJ2
3 PROJ3
EMPLOYEE
EMPID EMPNAME DPT
A aaa TECH
B bbb VENER
C ddd CARV


i store details in my master table in this format

EMPID DATE PRJID HRS
A 1-6-04 1 5
A 1-6-04 3 4
B 1-6-04 2 9
C 1-6-04 2 2
C 1-6-04 1 2
C 1-6-04 3 5
* * * *
* * * *
* * * *
* * * *
A 30-6-04 3 9
B 30-6-04 1 9
C 30-6-04 2 9




i want a report - the time sheet for a
particular emp for a particular month

my problem is it s layout..
the first columns should contain -date
the rest of the columns in that row(heading)
should contain the contents of the table _PROJECT
(prjNames)

report should be

THE TIME SHEET OF THE EMPLOYEE-A FOR THE MONTH
JUNE-2004

---------------------------------
NAME (EMPID)A
---------------------------------
DATE! PRJID(1) !PRJID(2) PRJID(3) DAILY-TotAL
------------------------------- (generate)
1-6-4 5 * 4 9
2-6-4 4 4 1 9
3-6-4 4 4 1 9

4 2 3--hours--- 9
*** 5 4 9
*** 9 9
*** 4 2 3 9

Total ** ** ** 36

#this is important--the contents of the table, PROJECT-should be
in one of the heading and the corresponding timings should be displayed in
the columns below to the respective date fields