Cumulative totals for summary payments

[maxmaggot]

I have a feature I am going to work on on this db . It's on the Funds Page of the navigation bar. I have two text boxes that will show the total of all Christmas Cards ordered by a customer in the Type A range (A1-A5) and Type B (B1-B4) range.

You'll have to navigate to the last records to get the Christmas cards section to appear as it hides if someone hasn't ordered CCards.

I have two other text boxes that show how much each person has paid to date for A and B.

The user doesn't care which card was ordered, only the total price that is due for an A or B type card. The user also doesn't care how much has been paid to date except if its an A or B

I've been trying queries and the control source but I always fall down when trying to get the A and B ranges. I get an error message about missing syntax. I've had a look around and I just can't see the error.

I have removed private data from this db but it is large and it will throw up some input boxes. Just click cancel until they go away.

I'd really appreciate it if you had a look.

If you need the complete db I can share it with you and give you the xp points on the thread.

Here is my SQL attempt with no satisfaction

= SELECT Donations.[Donation ID]=Me.[Donation ID], ChristmasCards.TotalPrice, ChristmasCardTypesAndPrices.CCType
FROM ChristmasCardTypesAndPrices INNER JOIN (Donations INNER JOIN ChristmasCards ON Donations.[Donation ID] = ChristmasCards.DonerRegID) ON (ChristmasCardTypesAndPrices.ID = ChristmasCards.CCType) AND (ChristmasCardTypesAndPrices.ID = ChristmasCards.CardPrice)
WHERE (((ChristmasCardTypesAndPrices.CCType) Like "B*"));

[June7]

Make the subform a Continuous View and arrange the controls to look like Datasheet. Then can have textboxes in the subform Form header section with expressions like:

=Sum(IIf([CCType] Like "A*", [Total Price], 0))

=Sum(IIf([CCType] Like "B*", [Total Price], 0))

Otherwise, referencing controls on navigation form is a bit tricky, at least it seems so to me. Review https://www.accessforums.net/forms/t...orm-32053.html

[maxmaggot]

Thanks June,
That got it.