> It looks like my workaround will be as you suggested: > I would count the number of records first, if it is 0 then my next payments > no. would be 1.
Bernie: I don't see why your code doesn't work as is. If there are no payments, you get back 0, add 1 to it, and you get 1. If there are payments, you get the highest number, and add 1 to it to get the next number. -- Larry
