Running a query

[Toollady]

I have been attempting to create a query that will show when a job is paid. I have 2 tables 1-Invoice Line items, the other JobOrders. Each time I run the query I get several occurences of the same information. If I run the line items by itself I get part of what I need. The same is true if I run the JobOrders by itself, but the 2 together creates a mess.

[RayMilhon]

You'll have to put in a little more info. How are the 2 tables structured? How are they Joined???