lundi 29 mai 2017

MS Access: If/else condition to display data in a Form

I have created a form that allows a user to select a Company and input an Amount.
e.g.
Company Name | Taxable
ABC | YES
BCD | YES
CDE | NO
DEF | NO
...... and the list goes on

Currently, the form will display 2 calculated amounts for each company (YES and NO), with and without tax. How and where do I insert a condition such that my Form only displays the Amount with tax for YES and Amount without tax for NO?

Aucun commentaire:

Enregistrer un commentaire