How do I input more than one number in a single cell in access?

[Guest]

 

[Steve Schapel]

Tom,

To be honest, Access doesn't have "cells". And it is not normal
practice to enter more than one piece of information into the same field
in a single record. Can you please give an example of what you mean?

 

[John Vinson]

On Wed, 27 Sep 2006 11:18:02 -0700, Tom

It's considered polite to use the big white textbox rather than just
the subject line.

To answer your question, though, *you don't*. That's not how
relational databases work.

See the Relational Database 101 links at Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html



John W. Vinson[MVP]

 

[Joseph Meehan]

Use the big white box to give us some details.

Access database has records (sort of like spreadsheet rows)
Each record has fields, sort of like spreadsheet cells.

Do you mean something like 124 878 in one field? If so you can do that
by making the field a text type, not a number type. Of course you will not
be able to use the data in a mathematical calculation.

 

[David F Cox]

format(mynum1,"whatever") & " " & format(mynum2,"whatever")


I have used this to get two values into a crosstab value field e.g.
Number_of_members & percentage

It is not usual practise