I have a database recording all guests, those who have enquired and those who have reserved accommodation. Those guests who have reserved are given an individual invoice number and the amount of money received, recorded as “AmountPaid”
I wish to display a “Running Annual Income Total” of takings from the gusts who have reserved for “any particular year”.
Amongst many fields I have a “DepartDate” field and “AmountPaid” field.
Having tried several attempts at resolving this, I appear to be getting more and more confused. Any help would be gratefully received.