Report Display Issue

  • Thread starter Thread starter Q
  • Start date Start date
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
 
-"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.
 
No CrossTab can be used if you only have two fields

May
MCP in Access and SQL Server
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup in more groups 8
How to edit field name 1
problem with combo box 2
string type 3
Converting Text 9
CONDITION IN MACRO #2 2
Query finding minimum date 1
Need Query Help 0

Back
Top