total sales showing on a form

[Jen0dorf]

Hi

Have a database with two tables, one for customers and one for their purchases.

I've created a form structure which shows each customer with their purchases in a sub form.

I need to show the total value of all sales to all customers

I've created a query using this code:

SELECT Sum(Ornament.Cost) AS SumOfCost FROM XmasOrnaments;

This does when run show the total sales.

How can I use this query to show the total sales on my form?

thanks

Ian

[June7]

Why does the query reference two tables - Ornament and XmasOrnaments?

One option is expression in textbox that pulls data directly from table, query not needed: =DSum("Cost", "XmasOrnaments")

[Jen0dorf]

Hi

sorry was typo been a long day - outside lights for xmas :-) and then visit from 3 year old hyper grandson

that code sounds great my learning curve on VBA is slow but sure.

I did look at Dcount but rejected it as an option. Didn't come across DSum

off to rest my weary bones -

thanks

Ian

[June7]

Domain aggregate functions are not strictly VBA. They can be used in VBA but Access objects (queries, forms, reports) can use them just fine. DCount and DSum are only 2 of many.