Searchable Calendar

[John]

Hi,
How do I display a running total on my payments table, showing
totalised payments made by members of a club.Ideally it would be for display
purposes only and be placed in the form header or footer. I want to show
progress towards a financial target set by the club........say $10,000 and
for this amount to be consistently decremented as additional subscriptions
are made.? Tia John

 

[Ed Robichaud]

One of the common solutions is to use an unbound control on your form, and
use a DLookup calculation as its control source - something like:
DLookup("[maxtotal]","myTable") - [thisPayment]

-Ed