Hi everyone! I do apologise in advance if this is a really basic problem/ I've done something wrong. I'm an Access newbie and only really ventured into building my first proper database last year.
I'm trying to build my first financial report, and I'm having troubles with the sum expressions that I've tied to a couple of textboxes.
As you can see, I have the Amount per block tied to the 'payment type'. This correctly lists how much each booking is for.
I have added the textbox 'Running Sum' (the one that's listing £216, £432 and £648), using the expression
, expecting it to list £0 under Direct debit, and £72, £144 and £216 under 12 Weeks:Core Skills. I'm really confused as to how it's actually getting it's data, since it's entirely wrong! I have the 'Running Sum' property set to 'Over Group', which I think is correct. Both the text box and the field in the table it draws its data from are set to currency,
The textbox displaying #Error, should be displaying a sum from the overall report (total). Its control source expression is also
, so I'm confused why it's returning an error. If anyone has any insight I'd appreciate it greatly! I can also supply further information/ screenshots if required.
I'm trying to build my first financial report, and I'm having troubles with the sum expressions that I've tied to a couple of textboxes.
As you can see, I have the Amount per block tied to the 'payment type'. This correctly lists how much each booking is for.
I have added the textbox 'Running Sum' (the one that's listing £216, £432 and £648), using the expression
Code:
=Sum([Amountperblock])
The textbox displaying #Error, should be displaying a sum from the overall report (total). Its control source expression is also
Code:
=Sum([Amountperblock])