Access

I created a table with a few queries. Now I need to add to the table. I
need to add columns for Children (sex and ages) and pets (what kind). Is
there any way of creating a sub-column to keep the data for each individual
new column together?

Thanks

Use an update query. Go to help and type update.

"CiCi" wrote:

I created a table with a few queries. Now I need to add to the table. I
need to add columns for Children (sex and ages) and pets (what kind). Is
there any way of creating a sub-column to keep the data for each individual
new column together?

Thanks

On Wed, 22 Oct 2008 08:52:01 -0700, CiCi
wrote:

I created a table with a few queries. Now I need to add to the table. I
need to add columns for Children (sex and ages) and pets (what kind). Is
there any way of creating a sub-column to keep the data for each individual
new column together?

Thanks

STOP!!!

It sounds like you're working directly in table or query datasheets. These are
*very* limited.

It also sounds like you're trying to grow the table wider, with new fields for
Child1, Child2, Child3... Pet1, Pet2, Pet3... This is incorrect. Tables grow
vertically with new records, not horizontally. You would want a *new table*
for Children, related one-to-many to your current table; each new child would
be a new record in this table.

To interact with the data you would use a Form, probably with a couple of
Subforms (a subform for children and one for pets, for example).

See the tutorials at

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

for examples of how to design databases.
--

John W. Vinson [MVP]