Report Display Issue

[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

 

[Rick Brandt]

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

Crosstab query. Look in the new query wizard.

 

[May]

No CrossTab can be used if you only have two fields

May
MCP in Access and SQL Server