RE: [MS_AccessPros] Manipulating data.

Are these your actual field names? What is stored in the fields? Are there other significant fields?
I expect you can use a normalizing union query like:
SELECT ClubName, [Posn1] As Posn, 1 as Position
FROM tblNoNameProvided
UNION ALL
SELECT ClubName, [Posn2], 2
FROM tblNoNameProvided
UNION ALL
SELECT ClubName, [Posn3], 3
FROM tblNoNameProvided
UNION ALL

SELECT ClubName, [Posn4], 4
FROM tblNoNameProvided
UNION ALL
-- and so on --

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: robinski@mymail.net.au
Date: Tue, 31 May 2011 13:34:51 +1000
Subject: [MS_AccessPros] Manipulating data.

I have a database that has been presented in the format:

ClubName - Posn1 - Posn2 - Posn3 - Posn4 - Posn5 - Posn6 - and so on.

I need it in the format:

ClubName - Posn1
ClubName - Posn2
ClubName - Posn3
ClubName - Posn4
ClubName - Posn5
ClubName - Posn6

How do I manipulate the original data?

Many thanks,

Robin Chapple

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/