Duplicate Rows

J

JLong

Is it possible to avoid row repetition, on a result table
in Access2000. I have two tables Customers and Projects.
I am trying to print a list of all customers for whom we
have projects in process. When I run the query I get some
customers repeated many times because they might have
various project in process. Is there a way of eliminating
this problem (repetition of row in a result table). I am
not very experienced in this. Hope someone will give me a
hand
 
H

Homeslice

You might wanto to edit the relationships between the two tables. Go to the
database window and click on the Relationships button, and then modify as
needed. HTH.
 
J

John Vinson

Is it possible to avoid row repetition, on a result table
in Access2000. I have two tables Customers and Projects.
I am trying to print a list of all customers for whom we
have projects in process. When I run the query I get some
customers repeated many times because they might have
various project in process. Is there a way of eliminating
this problem (repetition of row in a result table). I am
not very experienced in this. Hope someone will give me a
hand
Click to expand...

That's exactly how a Query works. If you want to suppress the
*display* of the repeated fields in a Report, set the properties of
the textbox in which the customer fields are displayed to Hide
Duplicates; or you can use the Report's Sorting and Grouping facility
to put the customer information in a Group Header and the projects in
the Detail section.

On the other hand, if you want to see each customer once on a Form
together with their Projects, use a Form based on the Customer table
with a subform based on Projects.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top