Hello everyone! This should be a pretty easy question:
Okay, so I have a report that groups information from a query, and subtotals a payable amount. It looks something like this:
Group A..... Item#... PAYABLE
1...........$50.00
2...........$23.00
subtotal: $73.00
Group B.........Item #.....PAYABLE
3..........$16.00
4..........$200.00
subtotal: $216.00
What I'm trying to then do is have a section on the bottom of the report that takes each subtotal amount (the $73.00 and the $216.00) and multiplies it by 95%. I want it to look like this:
Group A: $69.35
Group B: $205.2
I need it to be in the report footer. So I put in some text boxes, go to their properties, and under the "data" tab where I enter in the control source, I try to type in an expression but none of them work.
I can't get Access to isolate each of the subtotal amounts:
Control Source = [AccessTotalsPAYABLE]*.95
But doing this results in Access taking the grand total from my PAYABLE field instead of each subtotal.... How can I write my expression so that Access will let me use the value from each subtotal?
Thank you in advance for your help!