Distinct records in report

[Dave]

Hi all,

I'm new to Reports, so please bear with me.

I have a query that produces a list of participants by project. It
also produces a list of files by project (participants and files are
both many-to-many joins with project):

_Project_ _Participants_ _Files_
Project1 participant1 file1
Project1 participant1 file2
Project1 participant1 file3
Project1 participant2 file1
Project1 participant2 file2
Project1 participant2 file3

What I want in the report that's based on this query is something like
this (my reports so far are exactly this pretty):

_Project_
Project1

_Participants_
participant1
participant2

_Files_
file1
file2
file3

Basically, I need something like a DISTINCT for participants and files,
I only want one of each unique value for each project.

Thanks for any help in advance (especially if it doesn't involve VB :)

Cheers,

Dave.

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In the report create 2 groupings: one for Projects, the other for
Participants. Each should have a Header section. Place the data
control for Projects in the Projects Header section and the data control
for the Participants in the Participants section.

In the Details section place the Files data control.

Done.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRAdfy4echKqOuFEgEQImkgCfTCfNOasR2SR+EGDVg2Mijz OePKkAn0kl
11kdADsz9V78bs7p1XQQyhSd
=1WeB
-----END PGP SIGNATURE-----
Dave wrote:

Hi all,

I'm new to Reports, so please bear with me.

I have a query that produces a list of participants by project. It
also produces a list of files by project (participants and files are
both many-to-many joins with project):

_Project_ _Participants_ _Files_
Project1 participant1 file1
Project1 participant1 file2
Project1 participant1 file3
Project1 participant2 file1
Project1 participant2 file2
Project1 participant2 file3

What I want in the report that's based on this query is something like
this (my reports so far are exactly this pretty):

_Project_
Project1

_Participants_
participant1
participant2

_Files_
file1
file2
file3

Basically, I need something like a DISTINCT for participants and files,
I only want one of each unique value for each project.

Thanks for any help in advance (especially if it doesn't involve VB :)