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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multi if then Expression as query column using input parameters 4
Multiplying values in columns 2
Multiplying field in query 7
Why does it multiply my 'sum' by 17? 14
VLOOKUP 2
Counting in Queries Ends Up Multiplying 2
how do I multiply two columns one by another? Thanks 5
Calculating column A * column B = Results in another column 2

Back
Top