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
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