Adding values froma field to a totals box

D

DBE

I have modified the Orders database from the Microsoft Website to suit my own
needs however I need to create a subtotal box on the main form which adds the
total price for each item and displays the total amount an order has cost. I
have used sum but it just seems to error! Help What am I doing wrong? I am
using Access 2003.
 
D

Duane Hookom

It's a bit difficult to know what you did wrong when we don't know what you
did.
My WAG is that you attempted to Sum() a text box control which you can't do.
You can only sum expressions based on field from your record source.
 
D

DBE

I have a price field in my products table which is multiplied by the quantity
ordered in my orders table There is also a total quantity ordered price
field for each item in the orders table. I would like to sum this field to
ensure I have a total spend on each order I'm sure its a field from a table
and definitely not a text box. I'll go check!
 
D

DBE

Hi again,
I checked my work and the data is definitely coming straight from the
products table. I dont know why it doesnt work????
 
D

Duane Hookom

We don't know either since you haven't provided any expressions or control
sources.
 
Top