Records not containing condition

  • Thread starter Thread starter Ramesh
  • Start date Start date
R

Ramesh

HI,

I have a Job table with Job ID and Job Description. There is an Action
table with Job ID, Action Date, ActionTaken and CurrentStatus.

The CurrentStatus contains Pending or Complete.

I want to make a query to list the latest status of each jobID. That is the
CurrentStatus in the record of the latest ActionDate of each Job ID.

Could somebody help with this one please?

Thanks very much
Ramesh
 
Ramesh,

Make a query in the sense of :

SELECT * FROM [Action Table] ORDER BY ActionDate ASC, JobID

(if I understood you right; this is a VERY basic question ...)

Kind regards

flupp
 
Thanks Flupp.

The query you have suggested will show all records. What is required is
only the last record in each JobID.

For example, if there is a job which has been attended 3 times, the first
two records will have status Pending. The third entry will have Complete.
Only the third entry is required in the query.

I am only a novice and this may be basic. But my basic knowledge isnt
working!

Thanks again
Ramesh

flupp said:
Ramesh,

Make a query in the sense of :

SELECT * FROM [Action Table] ORDER BY ActionDate ASC, JobID

(if I understood you right; this is a VERY basic question ...)

Kind regards

flupp

Ramesh said:
HI,

I have a Job table with Job ID and Job Description. There is an Action
table with Job ID, Action Date, ActionTaken and CurrentStatus.

The CurrentStatus contains Pending or Complete.

I want to make a query to list the latest status of each jobID. That is the
CurrentStatus in the record of the latest ActionDate of each Job ID.

Could somebody help with this one please?

Thanks very much
Ramesh
Click to expand...
Click to expand...
 
Back
Top