Sum Results on form from query

[hullstorage]

Hi all i am trying to create a query that adds up all my subtotals for a given customer when selected from a combo

i.e. when i select a customer name from the combo on my form
the total amount of sales is shown on my form

this is so i can export these reults into another table

thanks

simon

 

[Fifty2One]

You should do this directly on the form using sum([fieldname]) as a text box's datasource with the appropriate fieldname in the squair brackets.

 

[namliam]

i.e. when i select a customer name from the combo on my form
the total amount of sales is shown on my form

this is so i can export these reults into another table

Hi simon,

Information that is easily calculated SHOULD NEVER be stored in any table anytime anywhere.!!!