Hey guys.
This is a real basic question but I am a newbie at this.:confused:
I have created a form in Access that is actually an INVOICE for my company and therefore I have fields like [qty1],[rate1] & [amount1]

In the form in [amount1] I have used the following expression to get automatically generated values.
=[qty1]*[rate1]

This gives me the Amount. But problem is that the result that is automatically generated by this mathematical operation is not stored in my database under the field amount1 and the field is therefore blank. I wish to use this resulted value in a report and also want to use it in other forms e.g. my sales register.

kindly help me out with this.:)

Hey guys.
This is a real basic question but I am a newbie at this.:confused:
I have created a form in Access that is actually an INVOICE for my company and therefore I have fields like [qty1],[rate1] & [amount1]

In the form in [amount1] I have used the following expression to get automatically generated values.
=[qty1]*[rate1]

This gives me the Amount. But problem is that the result that is automatically generated by this mathematical operation is not stored in my database under the field amount1 and the field is therefore blank. I wish to use this resulted value in a report and also want to use it in other forms e.g. my sales register.

kindly help me out with this.:)

You should not store calculated fields in a table. You could create a query with Amount1 as a calcuated field then set that query as the record source for a report or form.