query based on 2 tabels

[PAULBOL]

First off I am new to this forum and somewhat new to access 2010. We are trying to do a query based on two tables. The tables are joined by a field on both sides named “jobno”. In table one we are using a field “totalcost”. In table two we are using a field named “totalcost”. Totalcost in table one has 6 records, total cost in table two has 9 records. When we run the query we get 54 records. We have tried all possible join selection with the same results. Thanks in advance for any help.

[June7]

Do all 15 records have the same jobno value? If so, every record in each table is joining to every record in other table because that's what query is instructed to do - join jobno to jobno. Maybe you really want a UNION query.