Ed,
Forget the table with the numbers 1 to 31; it's going to give you lots of
trouble!
Develop a query that gives you Reg Hrs, OT, Total Jobs Completed and etc for
each employee for each date. You need to add to the query a calculated field for
Month and a calculated field for year:
WorkYear:Year([WorkDate])
WorkMonth:Month([WorkDate])
Put the following expression in the WorkYear field's criteria:
[Enter Year]
Put the following expression in the WorkMonth field's criteria:
[Enter Month]
Add another calculated field to the query:
ColumnHeading:Format([WorkDate],"mmdd")
Change the query to a crosstab query. Follow the wizard's directions.
Create your report from the crosstab query.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com www.pcdatasheet.com
"ED" <damatoer@hotmail.com> wrote in message
news:add44510.0408031200.7da3ba87@posting.google.c om...[color=blue]
> I am currently developing a database that will spit out job completion
> stats each day of a given month. I have a table that has lists the
> number 1 through 31. I am using this as a static table. I have a
> query that for a given employee lists # of jobs completed, hours
> worked and other information for everyday of the month. If there is
> no data I have the day set to 0. I am trying to format this query
> into a report that would look like the following
>
>
> This would be grouped by employee
> 1 2 3 4 . . .31 (Days always static)
> Regular Hrs 8 7
> OT Hrs 0 2
> Total Jobs Completed 22 18
> ETC
>
> I am having trouble creating this report. I know that this might not
> be enough information but I am looking for any ideas on how to
> accomplish this.
>
> Thanks[/color]
