I have a query that pulls up (lets say for simplicity sake), a client code, file number, last name, first name and invoice number...
CC, FN, LN, FN, IN
1 1 Smith, John, E123
1 2 Doe, Jane, E123
2 5 Renolds, Ron, E124
2 6 Black, Joe, E124
3 10 Tang, Jack, E125
So the query looks like that.. The problem is that I want to assign the first invoice number in the query (E123) and I need it to be the same for the same Client Code and then autotmatically increase by 1 for the next client code and so on...
Hope this makes sense.. Thanks in advance..
Julie
CC, FN, LN, FN, IN
1 1 Smith, John, E123
1 2 Doe, Jane, E123
2 5 Renolds, Ron, E124
2 6 Black, Joe, E124
3 10 Tang, Jack, E125
So the query looks like that.. The problem is that I want to assign the first invoice number in the query (E123) and I need it to be the same for the same Client Code and then autotmatically increase by 1 for the next client code and so on...
Hope this makes sense.. Thanks in advance..
Julie