Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Posts
    29

    Unanswered: Progressive Query

    In one of my tables I have a Yes/No field that users click if a job has been Issued [chkIssued] and a number field to show the week number (can be 1 - 52) that it was sent out [intIssuedWeek]. There is also a Yes/No field for when then job has been completed [chkCompleted] and a number field for the week number when completed [intWeekCompleted].

    The week number that a job was completed in should be the one directly after the week it was issued in, for example a job issued in week 36 should be returned in week 37.

    I have set up a query to show how many have been issued in a week and also how many were returned the following week. I want to be able to extend this query show that it shows the progress of work over the past 4 weeks, but I don't know how to do this. The main aim is to see how many jobs are outstanding.

    Sample data: Week 36 Issued 20 Week 37 Completed 16

    so say week 37 another 20 are issued I want it to show 24, as 20 have been issued and 4 are uncompleted from the previous week.

    I hope I have made myself clear and not confused you too much. Any help on how I could do this would be greatly appreciated.

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    This is not difficult to do but is rather difficult to pinpoint the ultimate solution for your particular application without more information. It may be benificial to supply a small sample DB (with some table data) regarding your task and the basic Report you are using.

    Is it just a sumation of information you require or do you reguire (at any given point) a more detailed account of what is outstanding?


    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  3. #3
    Join Date
    Sep 2005
    Posts
    29
    The report I'm trying to get out of it is just a summary, no other detail is needed. I've attached a sample table with some data in it to see if its any help.
    Attached Files Attached Files

  4. #4
    Join Date
    Sep 2005
    Posts
    29
    I'm trying to produce a report that will show how many jobs are still outstanding with uncompleted jobs rolling onto the next week. An Example of the possible format would be

    ...............No of Issued Jobs .........No of completed jobs .......Jobs Outstanding

    Week 39 ...........20 ...............................16 ................................4

    Week 40 ...........20 ...............................19 ................................5

    Week 41 ...........20 ...............................21 ................................4

    Week 42 ...........20 ...............................10 ...............................14

    Hope this makes sense.

Posting Permissions

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