Calculation Field in a Form (Access 2003)

Topic

New Reply

I have an order details table that I need to store the quantity * the price. I can get it to show on the form but it is not being stored in the table.
Thank you in advance

Reply | Quote

Replies

Hi Robin

The best thing to do in this case is to create a query from the table which has the field

OrderAmount: [quantity]*[price]

and run the form from that query

Reply | Quote

How do I get the OrderAmount stored in my Order Details table.
Thanks

Reply | Quote

You don’t need to. The query stores the data and you can report on that.

Reply | Quote

Jerry is correct: unless there is a very specific reason for it, you shouldn’t store calculated information in a table. Tables should be used to store the basic data, and queries can be used to perform calculations based on those data. Storing calculated information takes up unnecessary space, and it might easily get out of date if you don’t take care to update it whenever the basic data are modified.

Reply | Quote

As others have pointed out, you don’t need to nor should you store calculated data in a table. You really should acquaint yourself with the process of “database normalization”. This encompasses some rules for the design of databases, with the purpose of ensuring the integrity of the data while maximizing the ability to use the data. Most Access books have at least a chapter devoted to this topic.

Reply | Quote

Thank you all for your help and suggestions. This is a wonderful form and everyone is so helpful.

Reply | Quote