Hey guys. The background to my issue is found under the thread "dimension dependent price on invoice".
Here is the issue I have now. The individual formulas all work fine to at finding the price of each line item. They look up the "girth factor" and everything. I just can not for the life of me figure out how to make the subtotal, tax, and total fields all work in the subform footer. I have attached a picture of my subform in design view hoping that helps you see my issue.
Also the formulas in each field are:
UnitPrice =(((2*[W])+(2*[H]))*(DMin("GirthValue","tblGirths","GirthType=" & "fkProductID" & " And GirthRange>=" & IIf([L]=0,1,[L]))))
LineTotal=([UnitPrice]*[Qty])
I have also tried bringing the "girth factor" found using the Dmin portion of the formula above into the form separately.
The forumulas I have in the footer are:
Subtotal=Sum([LineTotal])
Tax=((0.07)*[Subtotal])
Order Total=([Tax]+[Subtotal])
All I get is a balnk field. My understanding is that this is because I am trying to Sum a calculated field. I just don't know what to do instead.
I have tried recalculating in each field and this works perfectly until I go to the next record in the subform (add another item to the invoice). Then the fields display only the amounts for that single record.(Obviously).
I am a newbie so I'm sure I'm missing something.
Thanks for all your help in advance!