Getting multiple values in one Report field

[44nato44]

Hi

I hope you can help me, I have a table where I have multiple values like

TBL:
Name - KPI
Val1 - KPI1
Val1 - KPI2
Val2 - KPI1
Val2 - KPI3


I would like to make a report, which would show from this table the values like :
Name - Val1
KPI - KPI1, KPI2

Name - Val2
KPI - KPI1, KPI3


Is this possible or am I chasing a wild goes here ?

 

[dhookom]

You can either use a multi-column subreport or faq701-4233.

Duane
Hook'D on Access
MS Access MVP