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.

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:

Poskan Komentar