Need help!

[rainer]

Hi all!
Need some help with a query... because my skills in SQL are very poor.

I got a table in Access looking like this:

id orgno name address Account
1 123456 Test Testsson test.tesson@test.se 123456
2 123456 Test Testsson test.tesson@test.se 987987
3 123456 Test Testsson test.tesson@test.se 897878
4 987654 Svante Larsson svante@hem.se 154654
5 321654 Sture Sturesson sture@svampman.se 012365
6 321654 Sture Sturesson sture@svampman.se 000356

I need to have the output to look like this grouped by the orgno on one row with all users accounts.

Name Address Acc1 Acc2 Acc3
Test Testsson test.tesson@test.se 123456 987987 897878
Svante Larsson svante@hem.se 154654
Sture Sturesson sture@svampman.se 012365 000356

I have tried in many ways to solve this but now Im realy stuck...

Thanks in advance for all the help I can get on this issue!!
/Rainer

 

[Rich]

Try a crosstab query

 

[rainer]

How do I do that in Access, I cant get it to work...

/Rainer

 

[emshim]

when you go to create a new query, click on new, and there is an option to create cross tab query in there.

 

[emshim]

excuse me, "crosstab query wizard"