Report Display Issue

Q

Q

Hi,

If I have a table like the one below :

RouterName ServiceName

Rlondon SA
Rlondon SB
Rlondon SC
RParis SA

How can I get it to display like the report below :

Rlondon SA SB SC
Rparis SA
 
R

Rick Brandt

-"Q said:
Hi,

If I have a table like the one below :

RouterName ServiceName

Rlondon SA
Rlondon SB
Rlondon SC
RParis SA

How can I get it to display like the report below :

Rlondon SA SB SC
Rparis SA
Click to expand...

Crosstab query. Look in the new query wizard.
 
Top