How do you get the latest date?

[radicrains]

Here's the table I've created on Microsoft Access...

DrawingNo. Title RequiredDateToClass Revision1 Revision2 Revision3 LatestDate
1813-52.00 MAST 23/01/10 27/01/10 30/01/10 -
1813-56.00 RadioRoom 25/12/09 29/12/09 06/01/10 08/01/10
1813-67.00 ControlRoom - - - -
2729-01.01 IPMS 02/04/10 05/05/10 - -
3076-41.01 FDS 13/01/10 - - -



Right now, the situation is that, from all of these revision date, I need to extract out the LASTEST revision date.. Hence, I'm need to be able to come up with an end product of the below table..

DrawingNo. Title RequiredDateToClass Revision1 Revision2 Revision3 LatestDate
1813-52.00 MAST 23/01/10 27/01/10 30/01/10 - 30/01/10
1813-56.00 RadioRoom 25/12/09 29/12/09 06/01/10 08/01/10 08/01/10
1813-67.00 ControlRoom - - - - -
2729-01.01 IPMS 02/04/10 05/05/10 - - 05/05/10
3076-41.01 FDS 13/01/10 - - - -





I understand that there is a query that allow us to MAX the date. However, in Microsoft Access, the the MAX formula is only applicable to the table's column, not it's rows.. Hence, I need to know is there any other way for me to extract the latest date in Microsoft Access.. I've been trying to figure it out, but because I'm still new to Access, I still need guidance..






Please be patient with me.. I'm very new to access and I'm learning it because I'm doing a project for my internship.. Hence, SQL queries are definitely a no no to me.. i need explanations that are simple yet direct..



Thanks..

Regards,

Radicrains

[radicrains]

Sry if the tale i"ve type above is screwed.. here's a print screen of the table that I've sent out on earlier emails for help from others...
2 pictures:- Non-extracted table & Extracted date table(end product)


thanks..

[pbaldy]

This may help:

http://support.microsoft.com/default...b;en-us;209857

[radicrains]

This may help:

http://support.microsoft.com/default...b;en-us;209857

Thank God i have some background basics on programming.. Thank you so much for your help!
because of your help, i'm am able to accomplish this project.. May God bless you..

[pbaldy]

Happy to help, and welcome to the site by the way!

[radicrains]

Hey pbaldy,

Do you mind answering a few more questions that i have in my doubts...

Refering to Picture: Untitled

Since you've given me the solution of extracting the latest date, now i have 2 dates. LatestReceive & LatestReply dates.. Now, Out of this 2, I need Access to know the latest Date and also need to know from which column it comes from..

Refer to picture: Overdue

Access needs to be able to know if there is no Revision date, the drawing is overdue. And if the drawing is overdue, it must be able to reflect in the end product...


I'm not sure if I'm making any sense, My brain is fried trying to think. hahahaha.. Sorry if my words make the things more compliacted, but i think if u look at the pictures, it will be a better understanding.. thanks..

[radicrains]

Ah, nvm.. Got it solved!