Query duplicate values

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!!
..
 
G

Guest

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

Combing the Output from Two Queries 1
query with zero records 6
Complicated Query Update 4
Expressions for parameters in query 3
SQL help 2
SQL help - queries very slow 1
SQL keeps getting deleted!??? 2
Circular Reference error message on a query 1

Top