AnsweredAssumed Answered

Annual Income Takings

Question asked by RogerBirch on Aug 11, 2016
Latest reply on Sep 7, 2016 by philipHPG

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.

Outcomes