Please help with converting from Sql to MS Access 2003


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!
 
Ad

Advertisements


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

Top