Status update query
- From: rama <chanattu@xxxxxxxxx>
- Date: Sat, 31 May 2008 09:46:27 -0700 (PDT)
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
.
- Prev by Date: Re: "Record Deleted"
- Previous by thread: Re: Fikter outrepeated values - IN JUST ONE FIELD
- Index(es):
Relevant Pages
|
|
