Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2003: rank with partition by

Status
Not open for further replies.

MSIsam

Programmer
Sep 29, 2003
173
US
Below is an example of some data that I would like to rank using MS access. It would be similar to using the window funstions of other database applications. Does anyone know how I would create an expression to come up with DATE_RANK?
Code:
CUSTOMER  DATE_OF_PURCHASE [b]DATE_RANK[/b]
LARRY        01/01/2006            [b]1[/b]
LARRY        02/05/2006            [b]2[/b]
LARRY        02/10/2006            [b]3[/b]
CURLY        05/01/2006            [b]1[/b]
CURLY        07/01/2006            [b]2[/b]
CURLY        07/03/2006            [b]3[/b]
CURLY        01/01/2007            [b]4[/b]
MO           01/01/2006            [b]1[/b]
MO           01/02/2006            [b]2[/b]
MO           01/03/2006            [b]3[/b]

Any Help would be greatly appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top