Hello,
I am very much a novice user of Microsoft Access and it appears my database teacher is too so here I am posting for help!
I have a hypothetical mail ordering company and I am attempting to generate an invoice for the orders.
I have frm_Order and frm_OrderProduct.
frm_OrderProduct contains all my product details, the cost of the product and a calculated Order Total (which includes shipment and any relevant discounts)
The initial Order Total (I have called this OrderTotal which is an invisible field) has this code:
Code:
=Sum([UnitCost]*[Quantity])+[Forms]![frm_Order]![Cost]-[Discount]
I then have a FinalOrderTotal which is a visible field which contains this code:
Code:
=[OrderTotal]-[Forms]![frm_Order]![RepeatedDiscountAmount]
I want the FinalOrderTotal to be displayed on my report.
I've added a text field and the Control Source is:
Code:
=[Forms]![frm_Order-Product Subform]![FinalOrderTotal]
This brings up a error of "#Name?"
I also tried using the code that makes up the FinalOrderTotal and altering it to be:
Code:
=[Forms]![frm_OrderProduct]![OrderTotal]-[Forms]![frm_Order]![RepeatedDiscountAmount]
which brings up the same issue.
Any help will be beneficial and likely better than my teacher(who came up with a solution by storing derived data)!