I have a table and or query with a list of bill #'s these and transaction dates
1. The bill # will duplicate with every transdate that is different
2. Every Tranaction date is not unique there are several other bill #'s with the same transaction date.
I need to have either VB or sql that will place a numbered sequence in the query or table to count the number of time the Bill # appears and place it in the table or query in the same row with the bill# it is counting. I have looked at several fuctions to complete this but have found nothing that complete what I am asking for, Dcount kind of worked but it did not count the records grouped but instead counted the grouped records. If anyone has any ideas please let me know, basically I need to do a running sum on a query or table to show the count sequence of grouped records.
This is what it looks like now:
This is what I need it to look like:
1 K8018JD 3/10/2008
2 K8018JD 3/24/2008
3 K8018JD 4/01/2008
4 K8018JD 6/10/2008
5 K8018JD 9/10/2008
6 K8018JD 11/01/2008
1 K80705G 3/10/2008
2 K80705G 3/24/2008
3 K80705G 4/01/2008
4 K80705G 6/10/2008