query info from two tables

[bobby]

i have a table with transaction information. i also have a
table with account rep information. not all transactions
get credited to an account rep. they will get credited if
the transaction occurs in a coverage area for the rep.
this coverage area info is contained in the acct rep
table. i am able to use a query to attach the acct rep
info from the one table to the transaction info from
another table through an INNER JOIN, however i am not able
to then retrieve the balance of the transaction info
(which should exclude the transactions returned in the
query through the INNER JOIN). any help appreciated as i
am new at this. thanks.

 

[Rick B]

If you right-click on the line between the two tables (in design view) you
can select "join properties" and tell it that you want to see all records
from tblTransactions and only those records from tbleAccountRep where the
joined fields are equal.

Rick B


i have a table with transaction information. i also have a
table with account rep information. not all transactions
get credited to an account rep. they will get credited if
the transaction occurs in a coverage area for the rep.
this coverage area info is contained in the acct rep
table. i am able to use a query to attach the acct rep
info from the one table to the transaction info from
another table through an INNER JOIN, however i am not able
to then retrieve the balance of the transaction info
(which should exclude the transactions returned in the
query through the INNER JOIN). any help appreciated as i
am new at this. thanks.

 

[Guest]

works great - rick b - youre the best!!!