carrybag93
Registered User.
- Local time
- Tomorrow, 01:09
- Joined
- May 24, 2012
- Messages
- 73
I've made an order form for my database based on the table 'Sales'. Four of the fields include:
VIP? (Yes/No)
After Discount (Currency Calculated)
Taxable? (Yes/No)
After GST (Currency Calculated)
If the VIP box is checked, the After Discount field displays the Subtotal (another calculated field displayed before the VIP? field) -5%. This one seems to work fine. In the form, when I tick VIP?, 5% is taken off the Sub Total.
This is the expression I used:
IIf([VIP Discount?],([After Discount]-([After Discount]*0.05)),[After Discount])
I now want the After GST field to do the same, except take the amount in the After Discount field and add on 10% when the Taxable? field is ticked.
I put this expression in the After GST field:
IIf([Taxable?],([After Discount]+([After Discount]*0.1)),[After Discount])
but when I tick the Taxable? field, it changes nothing.
How do I fix this? :banghead:
VIP? (Yes/No)
After Discount (Currency Calculated)
Taxable? (Yes/No)
After GST (Currency Calculated)
If the VIP box is checked, the After Discount field displays the Subtotal (another calculated field displayed before the VIP? field) -5%. This one seems to work fine. In the form, when I tick VIP?, 5% is taken off the Sub Total.
This is the expression I used:
IIf([VIP Discount?],([After Discount]-([After Discount]*0.05)),[After Discount])
I now want the After GST field to do the same, except take the amount in the After Discount field and add on 10% when the Taxable? field is ticked.
I put this expression in the After GST field:
IIf([Taxable?],([After Discount]+([After Discount]*0.1)),[After Discount])
but when I tick the Taxable? field, it changes nothing.
How do I fix this? :banghead: