Column Data to Row data

[Guest]

A table contains comments from various faculty about various residents..I would like to pull all the comments on Resident X and get them in to a table where resident x is field 1, comment 1 is field 2, comment 2 is field 3, etc....is it possible?

thanks in advance.

 

[Douglas J. Steele]

While it's possible, it's not a good idea.

How many fields are you going to allow for comments? What happens when a
resident gets one more comment than that? How are you going to do queries to
see whether the same term appears in more than one comment?

It's much better to store each comment as a separate row.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

A table contains comments from various faculty about various residents..I

would like to pull all the comments on Resident X and get them in to a table
where resident x is field 1, comment 1 is field 2, comment 2 is field 3,
etc....is it possible?

 

[Joseph Meehan]

A table contains comments from various faculty about various
residents..I would like to pull all the comments on Resident X and
get them in to a table where resident x is field 1, comment 1 is
field 2, comment 2 is field 3, etc....is it possible?

thanks in advance.

To add to what Douglas said, think database, not paper. You are
thinking as if Access was a sheet of paper or a spread sheet.

 

[Guest]

OK. Thanks. I see what you mean.

While it's possible, it's not a good idea.

How many fields are you going to allow for comments? What happens when a
resident gets one more comment than that? How are you going to do queries to
see whether the same term appears in more than one comment?

It's much better to store each comment as a separate row.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



would like to pull all the comments on Resident X and get them in to a table
where resident x is field 1, comment 1 is field 2, comment 2 is field 3,
etc....is it possible?