Multiplying two query fields

[Harr777]

Hello,
I need to multiply two fields from a query. I can add fields, no problem. Anything that I try doesn't work (I'm using the "*&quot. Also, I'm working in query design view.
Any sugestions?
-Thanks

 

[dhookom]

"*" should work ie:
TotCost: [Qty]*[UnitPrice]

Duane
MS Access MVP

 

[Harr777]

Duane,
I should have explained; I'm trying something like this:

TotCost: (qryOther![Qty])* (qryOther![UnitPrice])

When I go to run the query, I get prompted for input values. This kind of thing worked elsewere for me with addition.

What I'm doing not is multiplying in a calculated control text box. At least that's working fine.

 

[jebry]

Hi!

First you need to do the standard things; make sure you got all of the spelling correct (you can use cut and paste just in case a stray space is the problem), make sure qryOther is actually included in the query. Finally, you can put square brackets around qryOther as well as the field names:

TotCost: [qryOther]![Qty]*[qryOther]![UnitPrice]

Access would normally do this for you once it recognized what you were doing. One last thing I would do is switch to SQL view and see what is coming out there.

hth


Jeff Bridgham
bridgham@purdue.edu