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
re******@pcdatasheet.com www.pcdatasheet.com
"ED" <da******@hotmail.com> wrote in message
news:ad**************************@posting.google.c om...
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
