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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL help - queries very slow 1
SQL help 2
Combine Duplicates in Query 0
Duplicate Query based on two duplicates 7
remove duplicate records in Access 2007 7
Duplicate Values in Query 1
Deleting duplicate records 3
divison by zero 2

Back
Top