Access Queries - Group in selection and in output

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Paw through the Northwind example, as it has a similar data structure.
Examine the queries to see how they do totals, etc.
 
Back
Top