take records out of table and put in new table

X

xololady

How do I delete records out of a table and put them into a new table? I am
doing a database for a club membership and am moving members around.
 
A

Allen Browne

See:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html

The article describes how to programmatically move records from one table to
another safely, using a copy and delete in a transaction. (It also discusses
when to do this.)
 
T

tina

if you have more than one table to list members, i suspect your tables
structure is not normalized. if you'd like to post an explanation of your
tables, perhaps we can help you ensure that you have a good basic design;
it's possible you don't need to "move members around" at all.

hth
 
X

xololady

It is a member list for a teen center. Some kids have graduated and moved
away, so I want to take those kids out of the main table and put them in
their own table so I don't lose their information. I have tried to do
queries that don't list them, but in the reports they show up. I don't know
anything about relationships. Please tell me what you mean by normalized.
 
R

Rick Brandt

xololady said:
It is a member list for a teen center. Some kids have graduated and
moved away, so I want to take those kids out of the main table and
put them in their own table so I don't lose their information. I
have tried to do queries that don't list them, but in the reports
they show up. I don't know anything about relationships. Please
tell me what you mean by normalized.
Click to expand...

So base your reports on the queries that don't list them.
 
T

tina

the Access tool was created for use with relational data. if you want to use
it effectively and harness its' power, you need to learn the basics of
relational design principles (normalization). for more information, see
http://home.att.net/~california.db/tips.html#aTip1.
Some kids have graduated and moved
away, so I want to take those kids out of the main table and put them in
their own table so I don't lose their information.
Click to expand...

i guessed as much. you can add a field "Inactive" (or whatever you want to
call it) to the table of members, data type Yes/No or Date/Time (depending
on whether you want to record *when* a person has become inactive, or simply
inactive yes or no). build a query based on the members table, with criteria
on the Inactive field (False if it's a Yes/No field, or Is Null if it's a
Date/Time field). as Rick said, base your report on the query, not directly
on the table.

hth
 
J

John W. Vinson

I don't know
anything about relationships. Please tell me what you mean by normalized.
Click to expand...

Do listen to Tina's and Allen's and Rick's good advice. Some tutorials
(including Allen's) can be found at:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/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

John W. Vinson [MVP]
 
Top