Duplicate entry in my query

[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 $330.00 labor dollars are in the first column and
should only be listed one time. I think the discrepancy
has something to do with my joins but unable to determine
what is causing the problem. Help!!

 

[ChrisJ]

You have shown two lines that appear in your query result, and highlight the
duplication of the "$330.00 $0.00 1 "

What we also need to see is what those two lines should look like.
Do you want two lines?
Do you want only one line?
what would you like on a line that has no labor and travel costs?

Chris

 

[Elizabeth]

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

Instead of the example I included in my original message.

 

[ChrisJ]

I assume that you are trying to produce an invoice or statement style report.
If so you are an the right track, you just haven't gone far enough.

If you use your existing query as the basis of that report, then all you
have to do is group by the job number and put the labour/travel costs in the
group footer where they will only appear once.

If you really want this in just a query, then I'll need some info on the
structure of the table(s) on which your query is based