If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Queries - Group in selection and in output
Kindly assist me with this one
I am working with three tables A. Order B. Invoice head (Invoice header information linked to Order via Order number) C. Invoice line (Linked to invoice head via invoice number) Each invoice line will hold a product code, the value of the product plus several other fields. The value of the product can of course be both debit a credit. An order can have many Invoice-heads and an invoice head can have many invoice lines. Now I would like to design a Query that for certain product codes select them if the sum of product value for a booking/product for all invoice lines is 0. And the result should be grouped by Booking and product and show the total value of each product pr. booking. I have tried to make this work in the Query grid, but without success. Looking forward for your assistance Best regards Peter |
#2
|
|||
|
|||
Paw through the Northwind example, as it has a similar data structure.
Examine the queries to see how they do totals, etc. -- Steve Clark, Access MVP FMS, Inc. www.fmsinc.com/consulting. "Peter" wrote in message ... Kindly assist me with this one I am working with three tables A. Order B. Invoice head (Invoice header information linked to Order via Order number) C. Invoice line (Linked to invoice head via invoice number) Each invoice line will hold a product code, the value of the product plus several other fields. The value of the product can of course be both debit a credit. An order can have many Invoice-heads and an invoice head can have many invoice lines. Now I would like to design a Query that for certain product codes select them if the sum of product value for a booking/product for all invoice lines is 0. And the result should be grouped by Booking and product and show the total value of each product pr. booking. I have tried to make this work in the Query grid, but without success. Looking forward for your assistance Best regards Peter |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hide Specific rows. | Steve | Worksheet Functions | 7 | June 9th, 2004 09:27 PM |
Queries don't work after conversion to MS Access 2000 | Nel Kes | Running & Setting Up Queries | 1 | June 1st, 2004 01:55 PM |
Option group selection as query criteria | Tara | Running & Setting Up Queries | 1 | May 28th, 2004 04:18 PM |