why does it have two different results?

[kath]

I have two separate groups of tables and queries from one
source.

I am using the retrieval to my Word Merge files since
there are quite a bit of "IF...THEN...ELSE" in my merge
form letters, and not all data fields are available from
the datasource so some inputting is required.

I did the first query successfuly exampled as follows:
1. Built a query to retrieved Info: Last_Name,
First_Name,MI, Addr...
2. I built a table to incorporate the ad hoc data fields
such as Missing1, Missing2, ...
3. Then I built a query to combine all the items in the
query for retrieve data from the source and the empty
table with all the new field names to a final query data.

It worked like magic and my co-workers loved it since they
now don't have to input the names and addresses over and
over when they need to send something to a particular
group from the datasource.

My second attemp are the same except that I also needed
people's ID (NO Duplicates) in the final query. I don't
know what was wrong since the step one query pulled up
names perfectly normal (one record per person), somehow in
the combination process it had to make rows for the same
record/person.

Please help us poor laborers!

Kath

 

[John Vinson]

My second attemp are the same except that I also needed
people's ID (NO Duplicates) in the final query. I don't
know what was wrong since the step one query pulled up
names perfectly normal (one record per person), somehow in
the combination process it had to make rows for the same
record/person.

Please post the SQL views of the two queries, and describe what result
you're getting that you don't want (or vice versa).