OK, I give up. I’m using Access 2002, developing a database for my business based on the Northwind example database. Any suggestions for my problem will be very much appreciated.
I need to calculate GST (sales tax) conditionally – some of my suppliers charge it, some don’t. I have it set up so that that I tick a checkbox in the Suppliers form when they charge GST. Then under the Orders subform (which is created from an Order Details table, linked to the Suppliers table and inset into an Orders form), I should think I should be able to put this formula as an event procedure:
If [GST?] = True Then [GST] = [Subtotal] * 0.1
If [GST?] = False Then [GST] = 0
([GST?] is from the Suppliers table, [GST] from the Order Details table, and [Subtotal] is calculated based on other values from the Order Details).
This formula has no effect, not even an error message, no matter where I try it (eg try it as an After Update or On Exit event procedure under Subtotal events, or as a Before Update event procedure under GST events etc. (Trying at random now since nothing seems to be working).
The database does update the [GST?] field based on which product (and therefore which supplier) I am entering and is getting that right. i.e it knows when GST? is true or false for each product - So what should I be doing to tell it to calculate GST conditionally? I’m sure I’ve just made some dumb mistake since I’ve not delved this far into Access before, but some guidance as to what exactly that mistake is would be nice.
Thanks