Assigning orders based on date

[jhuber07]

Hello,
I have a list of email addresses with corresponding dates & times.

I'm trying to append the fourth field (below), which tells us (based on date & time, BY email address), "most recent for this email", "second most recent for this email",...

Email_addy_1,1/1/2005,1:00AM,2
Email_addy_1,1/1/2005,2:00AM,1
Email_addy_2,2/1/2005,5:00PM,3
Email_addy_2,5/1/2005,3:00PM,2
Email_addy_2,7/1/2005,4:00AM,1

Thank you!

 

[SkipVought]

Hi,

Just query and Order By EmailAddr, EmailDate Desc, EmailTime Desc

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[wtmckown]

Would not this value change whenever a new record is added that has a matching email address?

 

[PHV]

Do a keyword search in this forum for rank or ranking

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886