Hiding Duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one table and 3 join tables based on that first table. I need to
have a report that pulls information from all 3 join tables but eliminates
the duplicates. These are one to many tables. I have tried the "Hide
Duplicates" property but does not help me any.

My "ONE" table from the one-to-many relationship is called Volunteers. It
holds the Volunteer ID. I have another table, the 'many' table, that holds
their work interest. The work interest comes from another table called Work.
There's two other scenarios like this such as what months a volunteer is
available and what states they'd like to work in. I need one BIG report that
will house all of this info. It needs to show the Volunteer info plus the
list of states, work interests, and months available, with NO duplicate
records. I cannot do this no matter how hard i try.

I have searched all through the newsgroup looking for a solution and nothing
answers my question. Please help!!

Emily
 
Hi Emily. Would you express how you have related the
tables right now, For instance if you chain related these
tables you could end up with various duplications, and if
you than included autoID numbers you would not have true
duplicates since the autonumbers would vary.
Fons
 
Back
Top