Transferring records

[Drew Burchett]

I have a database in which I am having to sort records and place them in one
of two different tables. Most of this I have to do manually because which
table they go into is pretty much a judgement call. Could anyone tell me
how (if it's possible) I could write a macro that would allow me to select a
set of records from table A, click a button and have the selected records
transferred to table B (or C) and then deleted from table A?

Thanks for your time

 

[Van T. Dinh]

It sounds to me that you need to consider the Table Structure in your
Database first.

Each Table should, in general, represents an entity in your database. In
your case, you seem to have the Table A (being used as a temporary holding
area) and then decide on whether to move each record to Table B or Table C.
It sounds like you have 3 Tables representing a single entity. If these 3
Table have similar structure, it is a symptom that your database may has an
incorrect structure.

It is possible that you have 2 sub-types of the same entity and there fore
you have Table B and Table C???

 

[Drew Burchett]

What I am doing is attempting to "train" my Baysean spam filter. To do
this, I have taken a representative sample of the email headers that passed
through my system for the past month. I placed these in a table that shows
from address, to address, subject and the score they got the first time
through. From there I determine if the email was actually ham or spam and
place it into the appropriate table. I can then export these tables and
feed them back through the baysean filter for appropriate classification.

But, I think I did find a better way to do this by simply adding a yes/no
field to the original table and using that to mark the records.

 

[Bob Quintal]

What I am doing is attempting to "train" my Baysean spam filter.
To do this, I have taken a representative sample of the email
headers that passed through my system for the past month. I
placed these in a table that shows from address, to address,
subject and the score they got the first time through. From there
I determine if the email was actually ham or spam and place it
into the appropriate table. I can then export these tables and
feed them back through the baysean filter for appropriate
classification.

But, I think I did find a better way to do this by simply adding a
yes/no field to the original table and using that to mark the
records.

I know you did find the right way.

Q.