the SUM function.. please help, assignment due

N

Nicky

this is apparently the easiest question..ohh please help me

how do i find the total price of all stock items in the database.. it says
here (use total query and find the SUM of the price of the stock) <-- i can
do that.. the answer is $157.. but thats only for one of each item... how can
i multiply this price by the number of 'OnHand' stock...btw 'Price' and
'OnHand' are the field names
 
K

Ken Sheridan

In the 'field' row of the column in design view change it from the Price
field name to an expression which multiplies the price by the number in stock
(which I assume is what the OnHand field holds), e.g.

Total Stock Value: [Price]*[OnHand]

Again select 'Sum' as the aggregation operator in the 'Total' row for the
column. This will return a column headed Total Stock Value. You can of
course change the column heading to whatever you wish.

Ken Sheridan
Stafford, England
 

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

Need total amount of items purchsed for all the persons 1
Adding up row values 4
I would appreciate some help with a formula 3
How do I use the wildcard query to find words like "the" in the ta 2
How to get various purchased amount made by persons 1
SUM - IF - AND 7
Computing total sales with a query 2
Minimum function in a list 5

Top