Moving and Deleting Records

  • Thread starter Thread starter Nolan Habegger
  • Start date Start date
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
 
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>
 
Back
Top