Duplicate Rows

[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

 

[Guest]

did u go to UD? sorry, OT.

 

[Guest]

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.

 

[Joseph Meehan]

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

I agree with Homeslice that you may be able to take care of it by
changing the relationship.

If not, create a report that counts the number of occurrences of each
name. Make the detail hidden so it does not print and the subtotal visible
so it prints.

 

[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

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