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