jdcallejas
Registered User.
- Local time
- Today, 17:02
- Joined
- Jul 1, 2008
- Messages
- 108
Hello,
I have a form called menu, here I create menu plates like Roast beef example. Roast beef is served with rice, bean, etc. When I create the menu, I add each ingredient that the plates use on a subform. When I pull the product ingredient it brings with it the average cost of the product.
So on the subform, I multiply the average cost by the amount I use for that plate. This calculation works fine for each individual ingredient. On the subform footer, I want to sum all ingredients on the subform calculated field. So I do a Sum([average]*[Quantity]) but I get an error.
I have the something working fine in the PO form, but here there is something wrong I can't figure out..,
Can you take a look at it.. Its the frmMenu
Thank you
I have a form called menu, here I create menu plates like Roast beef example. Roast beef is served with rice, bean, etc. When I create the menu, I add each ingredient that the plates use on a subform. When I pull the product ingredient it brings with it the average cost of the product.
So on the subform, I multiply the average cost by the amount I use for that plate. This calculation works fine for each individual ingredient. On the subform footer, I want to sum all ingredients on the subform calculated field. So I do a Sum([average]*[Quantity]) but I get an error.
I have the something working fine in the PO form, but here there is something wrong I can't figure out..,
Can you take a look at it.. Its the frmMenu
Thank you