how to multiply two columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all..

I have two fields
core value and quanity

What I want to do is have the core value multiply it by the quanity

$75.00 * 2 = $150.00

I tried this: =([Corevalue]*[Quanity]) placed it in the detail section. But
when this adds up it comes to $350.00

Thanks
R~
 
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

Lookup value in table from value in report query 13
Report with Monthly rows, Yearly columns & 3 pieces of data per mo 2
Help with report with query using subform 6
Sum of numbers 21
I wish to assign Quantity the value of [Quantity]-[OrderAmt] 1
FORMAT THE DATA TO ONE FEILD??????? 2
Need help buiding a worksheet. 1
setting fixed decimals in only one column of worksheet 2

Back
Top