| | |
|
|
|
Re: Records not containing condition |
|---|
| message from flupp on 5 May 2004 |
Ramesh,
SELECT * FROM [Action Table] ORDER BY ActionDate ASC, JobID
(if I understood you right; this is a VERY basic question ...)
Kind regards
flupp
"Ramesh" <ramborums@yahoo.com> wrote in message
news:uiJqLHpMEHA.2064@TK2MSFTNGP12.phx.gbl...
|
| Ramesh replied to flupp on 5 May 2004 |
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" <spam]@[microsoft.com> wrote in message
news:e0PLIrqMEHA.1608@TK2MSFTNGP12.phx.gbl...
|
|
Archived message: Re: Records not containing condition (MS Access Database)
