Hello,
I suspect there *should* be an easy way to do what I want, but I am having difficulty getting it right. Here goes...
Let's say I have the basic tables ORDERS and ORDERLINES. Each order can have many orderlines.
Now, I've created a query that gets the following:
From ORDERS: orderID, shipping
From ORDERLINES: product, qty, and linetotal (qty * price)
(I've simplified this somewhat)
I want a report that shows all orders (grouped by orderID), as well as all of the order lines for each order.
This is all fine, so far. At the end of the report, however, I would like the following:
1. The grand total of [linetotal] - OK
2. The grand total of shipping - this is where my problem lies.
I cannot figure out how to get a sum of the shipping. The shipping charge is part of each detail record as of now, but I just need to add one shipping amount per order.
Does this make sense? It should be easy enough to do, shouldn't it??!
Thanks for reading,
Gord
I suspect there *should* be an easy way to do what I want, but I am having difficulty getting it right. Here goes...
Let's say I have the basic tables ORDERS and ORDERLINES. Each order can have many orderlines.
Now, I've created a query that gets the following:
From ORDERS: orderID, shipping
From ORDERLINES: product, qty, and linetotal (qty * price)
(I've simplified this somewhat)
I want a report that shows all orders (grouped by orderID), as well as all of the order lines for each order.
This is all fine, so far. At the end of the report, however, I would like the following:
1. The grand total of [linetotal] - OK
2. The grand total of shipping - this is where my problem lies.
I cannot figure out how to get a sum of the shipping. The shipping charge is part of each detail record as of now, but I just need to add one shipping amount per order.
Does this make sense? It should be easy enough to do, shouldn't it??!
Thanks for reading,
Gord