x of y

[AmberO]

My database may have many payments for a client. Each payment record has a code to show whether it is valid or not. Each payment record also has a payment date.

Is there a way to only look at the valid payments (code = O) and then mark then as payment 1 of 3, 2 of 3 and 3 of 3, depending on their payment date? (much like the navigation buttons would do). I don't really need these values stored, I just need them to appear on a report.

Any help is most gratefully received,

Thank you

 

[Pat Hartman]

If you group by Invoice (or whatever constitutes a group of payments), you can define an unbound field with a value of:
=1 and set the RunningSum property to OverGroup.

 

[AmberO]

Thank you very much!!