Combining Reported Entries

[duecesup]

I have a one-many relationship between tblSDAC Accession and tblCA Sites

tblSDAC Accession contains SDAC Accession while tblCA Sites Contains SDAC Accession [and] CA Site number

I would like to create a report where SDAC accession is shown once and all CA Site numbers are represented together in a field.

Right now a new page is created for each CA Site number instead of in one reported field

i.e. SDAC 01
SDI-12584
Text Field Text Field

SDI-13584
Text Field Text Field

ETC.....
What I would like is:

SDAC 01
SDI-12584
SDI-13584
SDI-14854
Text Field Text Field
Is there a way to combine the entries in this way

Also, if this is possible is there a way to create a 2 column readout so entries are listed as

SDI-12584 SDI-15854
SDI-13584 SDI-16584
SDI-14854

Thanks.

 

[Premy]

Have u already checked out the Classify and Group feature in Access Reports?

HTH