Query duplicate values

  • Thread starter Thread starter Caroline
  • Start date Start date
C

Caroline

I have created 2 queries from the same table. When I join
these 2 queries to form 1 query containing all the data, I
get a duplication of records from the preceding record, if
there is no matching record on the other query. I used the
IIF expression to populate the field if the value is null,
and that still does not work. Example: There are 2 critera
which define queries - Divison/Fund Type. If there are 2
records on 1 query for 1 Divison & 2 fund types, the other
query has 1 record for the Divison & 1 fund type, the
second record is duplicated from the first record.
Help!!
..
 
Caroline,

Could you post the layout of your table? Also, if you
could post the sql from your querys, it would be helpful.
 
Back
Top