Help with Reporting

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • ED
    #1

    Help with Reporting

    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
    Tags: None
    • PC Datasheet
      #2
      Re: Help with Reporting

      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:F ormat([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@pcdata sheet.com
      https://www.pcdatasheet.com



      "ED" <damatoer@hotma il.com> wrote in message
      news:add44510.0 408031200.7da3b a87@posting.goo gle.com...[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]


        Comment

        Previous template Next
        Working...