Query Question

[Guest]

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

 

[Joseph Meehan]

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

Could you provide some more detailed information.

What fields and values are in the source of the query? If there is more
than one source please include what data comes from what source and how the
sources are related. Give an example of what you are getting and what you
want to get. Include any formulas you may be using in the query.

 

[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