Hi All,
I'm scratching my head with this one, but i'm sure someone here will have a solution.
I have an Access database with Order-Headers and Order-Lines in a Parent/Child relationship linked on the Order-Number. The Order-Lines table has fields for Order-Number, Item-Number, Qty, Item-Cost, Items-Net, %Markup, VAT, Items-Gross & some other descriptive fields. I want to create a query that shows the Order-Number plus the totals for all the items on that order. This I can do easily enough; where I'm stuck is how to get the query to show totals for any orders that have no lines. I realise that the Totals for an order with no lines will be all zero, but I need to see them in the query results.
Any help greatly appreciated.
Thanks,
Andrew
__._,_.___
Posted by: andrew@adwsystems.co.uk
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Save time and get your email on the go with the Yahoo Mail App
Get the beautifully designed, lighting fast, and easy-to-use, Yahoo Mail app today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar