Stop multiple IDs appearing in query

[Guest]

Im just learing about queries and have so far added 1 table to query and used
Is Not Null statment to stop records showing without the contact ID value in
the column 'ContactID. When I add another table with more data needed to
create a report I want to do it seems to repeat the Same ContactID mulitple
times on all of them. What simple way is there of adding a command in
criteria to show the values for each Contact ID, without repeating, using
this as the major ID in a series of tables added? Does that make sense???

 

[Dodo]

Im just learing about queries and have so far added 1 table to query
and used Is Not Null statment to stop records showing without the
contact ID value in the column 'ContactID. When I add another table
with more data needed to create a report I want to do it seems to
repeat the Same ContactID mulitple times on all of them. What simple
way is there of adding a command in criteria to show the values for
each Contact ID, without repeating, using this as the major ID in a
series of tables added? Does that make sense???

Have you linked the 2 tables in your qyery?

 

[Guest]

Yes but it doesnt seem to be making a diference, Ive just discovered that it
s not storing the contact ID when i add a new record to the other form. Yet
on other forms related to my contacts form are storing contactID where am I
going wrong???? Is it my relationship between tables or in the query???
Newbie of course