multiplication in access

Question

How can define one field of database by multiplication of two other fields?

Thanks

Answer 1

Create a query like normal. In an empty column in the grid, put something like [Field1] * [Field2] (replace Field1 and Field2 with the actual field names).

Assuming you want to give the calculated field a meaningful name, put that name in front, followed by a colon, like Product: [Field1] * [Field2]

Answer 2

While I believe it is possible in Access 2007, there's no logical reason why you'd need to do this.

As fellow Access MVP John Vinson likes to say "Storing calculated data generally accomplishes only three things: it wastes disk space, it wastes time (a disk fetch is much slower than almost any reasonable calculation), and it risks data validity, since once it's stored in a table either the Total or one of the fields that goes into the total may be changed, making the value WRONG."

Instead, create a query with a calculated field that multiplies the two values together, and use the query wherever you would have used the table.

Answer 3

Thanks,

How can I define a query with calculated field?