Weekly Crosstab Report

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?
 
K

KARL DEWEY

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?
 

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