Sabtu, 12 Maret 2016

[MS_AccessPros] Order Lines Totals Query


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.



Posted by:
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