Records not containing condition

[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

 

[flupp]

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]

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

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

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