Assign value of row counter

[anissw]

Hello- I have an export query that has number of distribution and CM distribution for invoices generated. The objective is to count the number of invoices based on the account number for each customer ID. Since the table has no primary key, the I assigned field number of distribution to 0 in hopes the counter will assign the value of the row number. The attached file shows how the current export displays and how it should display in the highlighted correct way section. I tried COUNT and DCOUNT methods which is the current setup, and they aren't working. Can someone help me? This will eliminate the need to go into the file and change the 2 fields.


Thanks-

anissw

 

[Guus2005]

Ranking the records.
There are several solutions for this particulair problem.

http://support.microsoft.com/kb/208946
http://blogannath.blogspot.com/2009/11/microsoft-access-tips-tricks-rank-every.html

HTH

 

[anissw]

Thanks so much. I'll test and give you an update.