G
Guest
Hi, The question I have is how to use an IF Statement with Access.
a. Using access I created a table made of 3 columns
1. ItemNum
2. Cost
3. Quantity
From this table I created a Query with these additional fields
1. SubTotal: [Quantity]*[ItemCost]
2. Tax: [SubTotal]*0.0825
3. Total: [SubTotal]+[Tax]
From this Query I create a Form – on this form I place a Radio button – If
the Radio button is NOT checked, the item is taxable – Then add tax to the
total. - If it is check, the item is not taxable, do not add tax.
That is it.
I am open to any suggestion such as using Radio button or check box, or …
In the query which develops the form and report, I do the calculation.
Please advice,
Tony
a. Using access I created a table made of 3 columns
1. ItemNum
2. Cost
3. Quantity
From this table I created a Query with these additional fields
1. SubTotal: [Quantity]*[ItemCost]
2. Tax: [SubTotal]*0.0825
3. Total: [SubTotal]+[Tax]
From this Query I create a Form – on this form I place a Radio button – If
the Radio button is NOT checked, the item is taxable – Then add tax to the
total. - If it is check, the item is not taxable, do not add tax.
That is it.
I am open to any suggestion such as using Radio button or check box, or …
In the query which develops the form and report, I do the calculation.
Please advice,
Tony