Adding up in Queries for a report.

[Foster]

Hi, please excuse me if this is an easy and/or a stupid question.
Still trying to figure it all out!!

I am trying to do some adding up in a query.

What I am trying to do is the following:

For Example.

I have 4 fields.

Item l Quantity l Buy Price l Sell.
A 1 £2.00 £3.00
B 1 £1.00 £2.00


Basically I need to get the profit/loss I need to work out (and put into a report) that I bought all items for £3.00 and sold for £5.00, therefore a profit of £2.00

I can get a query (though a query) to add up all the buy price's and all the sell price's , but not to multiple by the Quantity.
Hope this makes sense.

Many Thanks in advance.

 

[Mile-O]

Does this not work?

TotalProfit: [Quantity] * ([SellPrice] - [BuyPrice])

 

[Foster]

M.O.P, thanks for your reply.

What it needs to do is 1) add up the totals for each item.

A Buy=£2.00 Sell=£3.00
B Buy=£1.00 Sell=£2.00

Then 2) add up the total buys
Buy=£3.00, Sell-£5.00

and then 3) take the buy away from the sell.
The reason for this is that I also need to have the profit's for Item's A, B etc. ( I am being asked for these)

Once again, many thanks.

 

[Rich]

Calculate them on the report