Make Table Query, Count Assignment 1

[brahmabull525]

In Access, I'd like to create a Make Table Query that assigns an ascending "count" based on ID and Date. The data I have in a table right now looks like this:

ID Date
1 5/1/05
1 5/2/05
1 5/3/05
2 5/1/05
2 5/2/05
2 5/3/05

I'd like the Make Table Query to create an additional column in a new table called "Count". The final table would looke like:

ID Date Count
1 5/1/05 1
1 5/2/05 2
1 5/3/05 3
2 5/1/05 1
2 5/2/05 2
2 5/3/05 3

Help on how to do this would be greatly appreciated!!

Thanks!

 

[PHV]

Take a look here:

http://www.tek-tips.com/viewthread.cfm?qid=1065711

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

 

[brahmabull525]

PHV,

That's exactly what I needed! Thanks a lot!!