Unanswered: Getting many records summed in a query
I am making a database to manage paper delivery orders. I have 3 tables; the customer table (primary key, Customer No); the paper table (primary key, paper name); and order table (primary key, Order No).
The order table contains both foreign keys Customer ID and Paper Name. This has allowed a customer to have many papers delivered each day. I have successfully made some a nice form showing cutomer details with a subform showing all their paper orders and prices. On this form, I can create a totalling box summing the paper prices.
Unfortunately I need this weekly total figure in a table/query.
I have so far created a query with 2 fields: Customer No (from Customer Table) and a weekly cost field with the following DSum expression:
(qry_allcustomerorder is the query combining cutomer details and their orders)
As you can no doubt see, this simply adds up all the paper prices for every order and puts it as every customer's weekly total. I cannot for the life of me work out how to set the criteria to match the Customer No in qry_allcustomerorder to the Customer No in this query, and create an individual weekly total.
Can any one help me please?
Sorry if I've omitted some key info, or if it's a simple problem I'm taking a really roundabout route in solving!