Taking Info from One Table to Another

[CodeCracker0291]

Ideally, what I would like done is that I have Customer Status and basically I want if their status is Deceased or so I would like them to be taken out of the main table and placed in a seperate table. I probably would have to have a relationship or something. Please let me know. Thanks
-CodeCracker0291

 

[Mile-O]

Use an APPEND query to move the data into your other table with the criteria being on your Deceased field.

Then use a DELETE query to remove the records from your main table with the same criteria.

To build such a query, open the query editor and select Query from the menu.

Use the help to further understand the purposes and nuances of these query types.

 

[Pat Hartman]

The query takes care of all the records currently marked as deceased. What happens when you mark other records as deceased? Do you want the move to happen imediately?

 

[CodeCracker0291]

yes

Actually, yes I would.
Thanks