Adding .Value field problem

While making a database I added an existing field from the field list and it
inserted the field but every value shows up on a separate line and I would
like to have it on a single line, is there any simple way to fix this problem?

On Wed, 23 Apr 2008 13:05:01 -0700, Maul
wrote:

While making a database I added an existing field from the field list and it
inserted the field but every value shows up on a separate line and I would
like to have it on a single line, is there any simple way to fix this problem?

Um....

That's not a "problem". That's how databases work. Fields in a table should be
atomic, having only one value.

What is the nature of your data? What is the structure (now) of your table?
What would you LIKE to see? Please post a sample.
--

John W. Vinson [MVP]

"John W. Vinson" wrote:

On Wed, 23 Apr 2008 13:05:01 -0700, Maul
wrote:

While making a database I added an existing field from the field list and it
inserted the field but every value shows up on a separate line and I would
like to have it on a single line, is there any simple way to fix this problem?

Um....

That's not a "problem". That's how databases work. Fields in a table should be
atomic, having only one value.

What is the nature of your data? What is the structure (now) of your table?
What would you LIKE to see? Please post a sample.
--

John W. Vinson [MVP]


The field I am trying to insert was made as a multi value field that you
check marked which items would show for those companies. when i inserted the
field however they showed up on a separate line for each item making multiple
copies of the companies and their price quotes. i would like for the inserted
field to show all items on one line so that i don't wind up with duplications
of companies.