R
rama
I am looking for some help and advice to finish my access database.
In my access database I got table called ‘tblJobs’. There are some
fields – ID, Date, Job, Priority, Status, JobNo, etc. There are 3
status (completed / progress / pending). Some of the jobs need days to
finish. Where as some finishes at the same day. I have a query called
‘QRY_progress’ which will list out the in progress jobs. But here I
have the problem ie. I got a job with a job number ‘500’ and job ID
‘1000’ (job ID is auto number). Today Status of Job Number 500 is
progress, but tomorrow it is completed. So what happens is this job
will be reflected in ‘QRY_Pending’ and ‘QRY_Completed’. What I wish to
do is to set the status of all the progress jobs to ‘completed’ once
the job is actually completed. How to do this automatically.
Rama
In my access database I got table called ‘tblJobs’. There are some
fields – ID, Date, Job, Priority, Status, JobNo, etc. There are 3
status (completed / progress / pending). Some of the jobs need days to
finish. Where as some finishes at the same day. I have a query called
‘QRY_progress’ which will list out the in progress jobs. But here I
have the problem ie. I got a job with a job number ‘500’ and job ID
‘1000’ (job ID is auto number). Today Status of Job Number 500 is
progress, but tomorrow it is completed. So what happens is this job
will be reflected in ‘QRY_Pending’ and ‘QRY_Completed’. What I wish to
do is to set the status of all the progress jobs to ‘completed’ once
the job is actually completed. How to do this automatically.
Rama