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!)
Ron said:
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?
