Can anyone help me please?

[ignite]

Hello,

I have a small query problem, how would I determine the total amount of the products which make up an order please?

I have the following fields in my query...

OrderID, ProductCode, UnitPrice, Quantity, Amount: [UnitPrice]*[Quantity], Total

Now, I require the total to equal the value of all the 'amount' values, so basically the total cost of the order...is this possible please?

I was messing around with the =SUM expression but I couldn't figure out how to work it...

Thank you for any advice

 

[Mile-O]

Take Total out of the query - it's not needed.

On a textbox in a form put =Sum([Amount])

 

[ignite]

Well this information is linked as a subform to a form which displays the OrderID, Customer Number etc. I would like the total value of this order to be under these values so like..

OrderID
Customer Number
Total

When I tried what you stated it had an error as I'm guessing it didn't understand to look in the subform? Is there a way I can make it look in the subform as oppose to the query on the main form?

I have tried:

=Sum([FrmCustomersFormsOrdersSubform].Form![Amount])

But it came up with an error.

Thank you.

 

[ignite]

Ignore, fixed...thanks for the help.