Query Question

[Elizabeth]

I need help in determining why I'm getting duplicate labor
and travel costs in my query. For instance, if a service
order has one or more different parts and there is also
labor and travel cost - the labor and travel cost are
listed again each time the parts are listed. E.g.

$330.00 $0.00 1 $325.13 800- 0410- 01 Digital PCB Program/

$330.00 $0.00 1 $227.76 203005- 550 Top Enc. Assembly with

The entry should look like:
Labor Travel Qty Parts
$330.00 $00.00 1 $56.00
$00.00 $0.00 2 $156.00

 

[Pieter Wijnen]

Logical,
The Travel & Labor cost belongs to the service order (bet that ID and or
information is listed for each row also ;-))
The query is assumedly used for reporting so you would put the Travel &
Labor Cost in the Group footer (or header) of each Order and nobody would be
any wiser...

HTH

Pieter