Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reports (Access 97)

    Conditions: employees working on different programs during a time period. While they work on different programs they have different goals. The goals are based on data from the previous year and are by month. My Table for the employee is their name, date, hours worked, program, and their production. The historical data is by program and month. The report prints for each employee filtered by combo box on a form which has a "start date and end date". I can use the start date filter a query on the historical data by the month. I'm stuck on how I can get the month's historical data for the report and have it change with each program. In other words what was the goal for that program.

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports (Access 97)

    I would like to try and help, but I'm not quite sure I understand correctly... I have all kinds of questions based on what you've said so far... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Are you looking for help with the query to get the data for the report?
    Are the goals set by program? (ie... the same for every employee that will be working on that program)
    Does the production field in the Employee table get summed to find the percentage of goal achieved?
    Is there any way you could show us some sample data to see what exactly you are looking for?

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Reports (Access 97)

    You need to split some data out into additional tables. Hours worked, program and production should be in a separate table from the basic employee data. Add an employeeID to the employee table (you can use an autonumber, and I would recommend that approach) and put a matching employeeID field in the work table (make it a long integer in that table, not an autonumber). You may need an additional field for goals in the work table or perhaps that belongs in still another table, but it's difficult to tell with the information you've provided. You would create a one-to-many relationship between the employee table and the work table. Then you will be able to accommodate any programs the employee has worked on and you will be able to query out the information you need.
    Charlotte

  4. #4
    New Lounger
    Join Date
    Jun 2003
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports (Access 97)

    Thank you for the reply. My problem was only with the issue of matching the goal with the program. with the goal changing each month. After a meeting yesterday some things have changed <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> . They now will only need to meet the goals on the program that they had worked on the most during the period. That data would not be available until the end of the period although they need to be able to run interim reports. I will need to go back to the drawing board on this. I will repost if I need help I may be able to redesign around the problem. thanks again.

  5. #5
    New Lounger
    Join Date
    Jun 2003
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports (Access 97)

    Thanks for the reply. I know that its hard to make things clear when your trying to explain what your trying to do. My problem was only with the issue of matching a programs goals for the period on the report. I can have the goals in a table by program with entries by month or by month with entries by program. I could use the [Start Date] field on a form to filter a query. I had a report the ran for each employee that had the program with sum of the period followed by the detail of production for each day. I did have calculated fields that calculated their production. I needed a way to pull the goal for that program during that period to calculate their performance. Calculations haven't been an issue just the getting the goal. This is all mute now it has been decide that they will only be required to meet goals on the program that they worked on the most during the period. Along with some other changes it will be back to the drawing board for me. <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> I will repost if I need still need help. Maybe I can re-design my way out. Thanks again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •