Please help with converting from Sql to MS Access 2003

K

kralco626

Joined
Apr 14, 2010
Messages
1
Reaction score
0
I need the following to be converted to msaccess 2003

ROW_NUMBER() OVER (PARTITION BY MyTable.id ORDER BY MyTable.date DESC) as seq_num

This should, i think do what I want it to do. That is given a table as follows

id date
1 2009-08-08
1 2009-08-07
1 2009-08-06
2 2009-08-08
2 2009-08-07
3 2009-08-08
3 2009-08-07
3 2009-08-06

I should get this as a result

id date seq
1 2009-08-08 1
1 2009-08-07 2
1 2009-08-06 3
2 2009-08-08 1
2 2009-08-07 2
3 2009-08-08 1
3 2009-08-07 2
3 2009-08-06 3

Thanks so much for the help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab Query based on Ordinal Values 6
Odd results from Crosstab w/ Date/Time field 1
Totally stuck trying to format,loop etc...please help a novice!tha 20
Totally stuck trying to format,loop etc...re-post.please help 1
Autofil on variable rows, delete extract and show remaining rows 3
Help With Query for Two Tables with Different Structures 3
Qry returning too many records - join question 4
Fiscal year 2

Top