Moving and Deleting Records

N

Nolan Habegger

I'm new to Access and know just enough to be dangerous
when it comes to actions queries.

In the following table structure:

Table1
Name
Address
Phone

Table2
Name
Address
Phone

Table3
Name
Address
Phone

I am trying to perform the following actions:

WHERE Table1.Phone=Table2.Phone, I want to delete the
record from Table1 and append it to Table3.

I have a SQL statement that successfully COPIES the record
using an APPEND query, but that does not solve the
deletion issue.

Can someone compose a SQL statement that will do this?

Thanks,

Nolan Habegger
Houston, TX
 
J

John Vinson

I'm new to Access and know just enough to be dangerous
when it comes to actions queries.

In the following table structure:

Table1
Name
Address
Phone

Table2
Name
Address
Phone

Table3
Name
Address
Phone
Click to expand...

And why are you storing the SAME data redundantly in three tables!?
I am trying to perform the following actions:

WHERE Table1.Phone=Table2.Phone, I want to delete the
record from Table1 and append it to Table3.

I have a SQL statement that successfully COPIES the record
using an APPEND query, but that does not solve the
deletion issue.
Click to expand...

You need two queries; an Append query followed by a Delete query. Or
you may want to go with a different design:

Addresses
LastName
FirstName
Address <possibly Address1, Address2, City, State, PostCode>
Phone
Category <1, 2, or 3>
 
Top