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