Hi
I have a table in which I want to Group Records Together:
Code Process Pages
56 3 S/S
56 3 S/S
56 3 S/S
56 4 S/S
56 4 S/S
I want to group by Code Process and Pages and I want to number the Groups 1, 2, 3 etc
so i want to end up with
Code Process Pages Group No.
56 3 S/S 1
56 3 S/S 1
56 3 S/S 1
56 4 S/S 2
56 4 S/S 2
Can I do this with a query? or do i have to loop thru recordset?
Thanks