Newbie question : Calculation on Queries

[mugen_rsx]

I have very simple calculation. I believe that I couldn't done it on table, so I calculation them on query (is it right?) . Example: "TotalAmount: [Quantity]/[QuantityPerPcs]" on the "Feild". I manage to done this part, but the "TotalAmount" on table doesn't have the number that I calculate on Query, is this normal? Or I should done something about it?

 

[maxmangion]

you are right in working your caluclations in queries, it is not recommended to store caluclated fields in tables. In fact the field which you created in your table which as you said is simply showing 0, you can delete that field, because you don't need it in your table.

 

[mugen_rsx]

Thank you for your help with such a detail answer!!

 

[maxmangion]

you're welcome