I am trying to calculate the Grand Total for my Order Items on my main order form using the SUM(). It displays on the subform itself but errorenter image description heres out on the main form. I find it hard to figure out where I went wrong after many days and my Acces skills are really beginner. Solutions suggested in the link bellow have not solve the problem. =SUM([Quantity]*[Price]) or =SUM(NZ([Amount],0))
OrderID is the PK in the order form and orderDetailID is the PK in the Order Details form.
Any Help would be highly appreciated MS Access Subform with fields with #Error in form view
I am using Access 2013 on Windows 10.