D
DRMOB
I have a field that I am populating based on a calculation in another form;
field name 'Total Granted'. I would like to have it populated based on
whether or not a check box is check. Currently this is the code in the field
I want populated:
=ItemSubFrm.Form![Total$ofItemsRequestedSubfrm].Form![Total Granted]
Below is what is found in the qry for the above:
TotalCost: Sum([QtyReq]*[CostPerUnit])
Less 10%: IIf([Total Approved]>1000,[Total Approved]*0.9) or
Total Granted: IIf([Total Approved]>1000,[Total Approved]*0.9,[Total
Approved])
I need to be able to waive the 10% if a checkbox named "Waive10%" on a form
named DataEntryForm, is checked and to populate the field with Total Granted
instead of Less 10%.
Can you help?
field name 'Total Granted'. I would like to have it populated based on
whether or not a check box is check. Currently this is the code in the field
I want populated:
=ItemSubFrm.Form![Total$ofItemsRequestedSubfrm].Form![Total Granted]
Below is what is found in the qry for the above:
TotalCost: Sum([QtyReq]*[CostPerUnit])
Less 10%: IIf([Total Approved]>1000,[Total Approved]*0.9) or
Total Granted: IIf([Total Approved]>1000,[Total Approved]*0.9,[Total
Approved])
I need to be able to waive the 10% if a checkbox named "Waive10%" on a form
named DataEntryForm, is checked and to populate the field with Total Granted
instead of Less 10%.
Can you help?