how do i multiply one column by another column in access 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top