Bringing Info From Two Table Together

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables created by queries.

Table One
AgentName AgentCode TotalPaidBusiness

Table Two
AgentCode TotalSubmittedBusiness

I have a query that pulls the AgentName, AgentCode, and TotalSubmitted
Business from Table One and TotalPaidBusiness from Table Two. My problem is,
my query won't show the records that only have TotalPaidBusiness or
TotalSubmittedBusiness. For some reason, it's only pulling the records that
have both TotalPaidBusiness and TotalSubmittedBusiness. Is there any way
around this?
 
You should have three tables:

Table One
AgentName AgentCode

Table Two
AgentCode TotalPaidBusiness

Table Three
AgentCode TotalSubmittedBusiness


Then make two one-to-many connections with TableOne being the "one" side of
the join.

Rick B
 
Back
Top