Query Shows Value Incorrectly from a Join

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

Guest

First of all, I am a new user of Access. My problem has to do with a query
over two tables. Table 1 has two records for one account number, Table 2 has
one. When I query to show the data from both tables, the value from Table 2
is shown twice, with each record from Table 1. Is there a way to show the
value from Table 2 once and the values from Table 1 twice?
 
Can you tell us more about the tables, the data they contain, how they're
related, and why you want to display the results the way you describe? What
you're currently seeing is the normal result when you join two tables where
the number of records differs; you'll get the number of records that is the
maximum in either of the tables.
 
Hi Ken

I have two tables. The first one contains billing rates. A customer can
have multiple billing rates, hence the reason why, for example, two records
exist in this table for the same customer. In the other table are
adjustments for customers. The number and amount of the adjustments is
independent of the billing rates. So what I have been asked to do is show
this customer with it's multiple rates, and show the adjustment(s), such as
they are. It is not the number of records that concerns me, it is that I see
the one adjustment with each of the two records making it appear, at least to
my ignorant eye, as two adjustments of the same amount instead of one as
there is.

Does that make more sense? I guess I am trying to create a report that
shows customer data from these two tables together.

PS: Happy New Year.
 
You need to decide which of the records in the billing rates is to be
displayed with the record that has the adjustment with it.

Or if you want to show all the billing rates with the adjustment, and have
them all be in one record together, then you'll need a query that returns
the billing rate from each record in the billing rates table as a single
field in the query's record.

You'll need to post more specific data examples and table structures /
fields for us to give you more suggestions.
 
Back
Top