How do I enter multiple conditions in one formula? Here is what I have. It only uses the last if/then in the formula.
if CStr({tbl_Item.Amount2})=" " and ({tbl_Promo.Scan}> {tbl_Item.Amount}) then
formula=({tbl_Item.Amount}*{tbl_Qty.Qty})
end if
If{tbl_Item.Amount}=CCur(0.00) then
formula=(({tbl_Promo.Scan}*{tbl_Qty.Qty})*CDbl ({tbl_Item.Amount2}))
end if
If CStr({tbl_Item.Amount2})=" " and ({tbl_Promo.Scan}<{tbl_Item.Amount}) then
formula=({tbl_Promo.Scan}*{tbl_Qty.Qty})
end if
if CStr({tbl_Item.Amount2})=" " and ({tbl_Promo.Scan}> {tbl_Item.Amount}) then
formula=({tbl_Item.Amount}*{tbl_Qty.Qty})
end if
If{tbl_Item.Amount}=CCur(0.00) then
formula=(({tbl_Promo.Scan}*{tbl_Qty.Qty})*CDbl ({tbl_Item.Amount2}))
end if
If CStr({tbl_Item.Amount2})=" " and ({tbl_Promo.Scan}<{tbl_Item.Amount}) then
formula=({tbl_Promo.Scan}*{tbl_Qty.Qty})
end if