Show most recent...

[deejay_totoro]

Hello all,

I have a table that records comments. Comments are entered by date and are linked to a master table. For example.

Master record 1
ID1 Comment 1 01/01/2000
ID2 Comment 2 02/01/2000
ID3 Comment 3 03/01/2000

Master record 2
ID5 Comment 1 12/01/2000
ID6 Comment 2 15/01/2000
ID9 Comment 3 22/01/2000

etc...

What I would like to do is show the most recent comment only. How might I do this?

Thanks a lot!

dj_T

 

[KenHigg]

Parse the integer out of the id and dmax() it?