Displaying the most recent date only

  • Thread starter Thread starter David
  • Start date Start date
D

David

I'm trying to build an appliction where a user can update
a project's status. The user will input the date, status
message and name of the person who updates the project.

I would like to run a report where I only display the
most recent status message.

Can anyone help please?

Thanks,
David
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Something like this:

SELECT *
FROM TableName As T
WHERE StatusDate = (SELECT MAX(StatusDate) FROM TableName
WHERE ProjID = T.ProjID)

ProjID is the Project ID that you have in the TableName table.


MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQEZTfYechKqOuFEgEQLHkgCeILjPZ9yC1wivRVDyNJG82bJo+N0An1PP
3EUwW1irORgwznIvf7eaSMkf
=CWan
-----END PGP SIGNATURE-----
 
Back
Top