i want to multiply one column by another.
A Allen Browne Dec 8, 2006 #2 Create a query based on your table. Type the expression into the field row. Example: Amount: [Quantity] * [UnitPrice] Note that you do not store the calculated total in your table. For more info, see: Calculated fields at: http://allenbrowne.com/casu-14.html
Create a query based on your table. Type the expression into the field row. Example: Amount: [Quantity] * [UnitPrice] Note that you do not store the calculated total in your table. For more info, see: Calculated fields at: http://allenbrowne.com/casu-14.html
