G
Guest
Hello,
First I must say that I'm a completly newbie, nevertheless I have been
looking through the forum (has been of great help) and have not found any
case like mine, hence I submit this question.
I'm using access for developing a simple budget system, the idea of this
system is to keep internal record of every budget given. In the form I've
created, I've got one text box in which I have the calculation of the amount
times the cost of each piece. I also have one button in which you can choose
wheter to add or not tax (in my country budgets are usually given in both
ways), if the person push the tax button, then the tax will be added to the
text box with the total. My question is this:
I have read that it's not a good idea to copy calculations in the forms to
the tables, so how can I do this calculation in the query keeping it simple
with a button in which people can choose wheter to add or not taxes? and if
copying the calculation in the form to the table is the best choice, how can
I do it? My text box has the following information:
=[CantidadF]*[Precio unitarioF]*SiInm([IVA],1.15,1)
Where [CantidadF] is the quantity field, [Precio unitarioF] is the price per
unit, the SiInm is the IFF operator and [IVA] is my button name. I really
appreciate any help you could give me and hope you all have a great day!
Greets,
Jonathan Renpening T.
First I must say that I'm a completly newbie, nevertheless I have been
looking through the forum (has been of great help) and have not found any
case like mine, hence I submit this question.
I'm using access for developing a simple budget system, the idea of this
system is to keep internal record of every budget given. In the form I've
created, I've got one text box in which I have the calculation of the amount
times the cost of each piece. I also have one button in which you can choose
wheter to add or not tax (in my country budgets are usually given in both
ways), if the person push the tax button, then the tax will be added to the
text box with the total. My question is this:
I have read that it's not a good idea to copy calculations in the forms to
the tables, so how can I do this calculation in the query keeping it simple
with a button in which people can choose wheter to add or not taxes? and if
copying the calculation in the form to the table is the best choice, how can
I do it? My text box has the following information:
=[CantidadF]*[Precio unitarioF]*SiInm([IVA],1.15,1)
Where [CantidadF] is the quantity field, [Precio unitarioF] is the price per
unit, the SiInm is the IFF operator and [IVA] is my button name. I really
appreciate any help you could give me and hope you all have a great day!
Greets,
Jonathan Renpening T.