Query results show duplicate data

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

Guest

First warning, I am a new user of Access.

Here is my dilema. Have two tables. Common field between them is an
account number. In Table 1 for account X there are two records with values
in two fields we'll call RATE_1 and RATE_2. In Table 2 for account X is one
record with a value in a field we'll call RATE_X. When I query, regardless
of the join type, the result is two records, fair enough, but the value of
RATE_X is shown twice with each record of RATE_1 and RATE_2.

Account RATE_X RATE_1 RATE_2
01234 100.00 12.00 14.00
01234 100.00 22.00 24.00

Is it at all possible to show the 100.00 RATE_X value only once?

Thanks
Sergio
 
You will get as many records as have different data, regardless of how you
join them.

If your problem is the displaying of the values, use a report to display it
the way you want.
 
Looking at this my thinking is that you probably should not have two tables.
If the purpose of the different rate fields is to perform calculations at
various percentages, then these calculations can be performed in a query
and there is no need to store the "rate" in a table. My suggestion would be
to repost with a less generalized question.

E
 
Back
Top