Copying rows depending on number of fields full

[tmpgovrel]

Hello,

I am trying to figure out how to copy a row of information depending on if there are values in certain fields of that row.

Below please find the tables of what I have and what I need:

WHAT I CURRENTLY HAVE Mtg MOCName Status Poc PocNumber Time Location Participant1 Participant2 Participant3 Participant4 1 Fred Conf Barb 4856145646 4:30 a Melissa Nick Patti Alicia 2 Joe Conf Brian 5854689875 5:00 b Patti Ally Kerry Alicia 3 Sam Conf Tim 5631463514 5:15 c Kerry Melissa Ally 4 John Conf Tom 7588961225 4:45 d Nick WHAT I NEED Mtg MOCName Status Poc PocNumber Time Location Participant 1 Fred Conf Barb 4856145646 4:30 a Melissa 1 Fred Conf Barb 4856145646 4:30 a Nick 1 Fred Conf Barb 4856145646 4:30 a Patti 1 Fred Conf Barb 4856145646 4:30 a Alicia 2 Joe Conf Brian 5854689875 5:00 b Patti 2 Joe Conf Brian 5854689875 5:00 b Ally 2 Joe Conf Brian 5854689875 5:00 b Kerry 2 Joe Conf Brian 5854689875 5:00 b Alicia 3 Sam Conf Tim 5631463514 5:15 c Kerry 3 Sam Conf Tim 5631463514 5:15 c Melissa 3 Sam Conf Tim 5631463514 5:15 c Ally 4 John Conf Tom 7588961225 4:45 d Nick As you can see, depending on the amount of participants, the row with the meeting information will be copied. If someone can help me figure out how to make this work with a query (or if it isn't a query so I can post it in the correct forum) I would greatly appreciate it! --Ally

[pbaldy]

Look at UNION queries:

SELECT Mtg, MOCName, Status, Poc, PocNumber, Time, Location, Participant1
FROM TableName
WHERE Participant1 Is Not Null
UNION ALL
SELECT Mtg, MOCName, Status, Poc, PocNumber, Time, Location, Participant2
FROM TableName
WHERE Participant2 Is Not Null

[pbaldy]

Also, I deleted your duplicate thread. Please don't post the same question multiple times.

[tmpgovrel]

Thank you very much for yourr help. Sorry about posting twice - will know not to do that in the future.

[pbaldy]

No biggie about posting twice, you don't know until somebody tells you. I take it the UNION query worked for you? It is basically normalizing the data.