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.
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?
Self Taught In ALL Environments.....And It Shows!