Weekly Crosstab Report

  • Thread starter Thread starter daveXP
  • Start date Start date
D

daveXP

I need to submitt a report weekly the lists my project time for the week.
I have a form in Access 2003 that I use to input all my daily activities
into tables. I would like to create a crosstab report that lists the project
number and cost code as row headings and the days of the week (Sunday,
Monday,...) as column headings. Then the time I worked on each project:cost
code by day of week as the body of the report. It would look something like
this:

XO EOC SUNDAY MONDAY TUESDAY...
901 101 1:30 2:00
547 108 4:00 5:00

And would cover all project time logged for the week. Totals at the bottom
of each column would also be helpful in a the report.

I'm having trouble building the crosstab query that will result in a column
for each day of the week regardless of whether or not I worked on projects on
a particular day, and I am also having trouble with a form to select the
datesI want to report on.
Could you point me in the right direction?
 
What is the name of the field and datatype used to store your time?
What is the name and datatype of the field used to store the activity date?
 
Back
Top