Macro help!

[Guest]

Help! I'm a new user with no macro programming experience and I'm trying to filter a list of records as such

Basically, I have 3 tables. 1 table contains the phone numbers that are the qualifier, so if a record on one of the other 2 tables has that matching phone number, then I want to delete that record or move it to another table thereby removing it from the table that it is on

Now, the other issue I have is that the phone number is broken up over 2 columns: one column is the area code and the other is the phone number

Can anybody at least point me in the right direction? I have no experience creating macros in access or excel

THANKS!

 

[Ken Snell]

See reply in m.p.a.macros newsgroup.

--
Ken Snell
<MS ACCESS MVP>

Help! I'm a new user with no macro programming experience and I'm trying

to filter a list of records as such:

Basically, I have 3 tables. 1 table contains the phone numbers that are

the qualifier, so if a record on one of the other 2 tables has that matching
phone number, then I want to delete that record or move it to another table
thereby removing it from the table that it is on.

Now, the other issue I have is that the phone number is broken up over 2

columns: one column is the area code and the other is the phone number.

Can anybody at least point me in the right direction? I have no experience

creating macros in access or excel.

 

[John Vinson]

Help! I'm a new user with no macro programming experience and I'm trying to filter a list of records as such:

Basically, I have 3 tables. 1 table contains the phone numbers that are the qualifier, so if a record on one of the other 2 tables has that matching phone number, then I want to delete that record or move it to another table thereby removing it from the table that it is on.

Now, the other issue I have is that the phone number is broken up over 2 columns: one column is the area code and the other is the phone number.

Can anybody at least point me in the right direction? I have no experience creating macros in access or excel.

THANKS!

Neither a macro nor code is needed for this; instead, you should use a
Query, the most powerful tool in the Access armamentarium.

You will need two queries to do this: an Append query to add the
records to the target table, and a Delete query to remove it from the
source table. This Query can join on a two-field phone number with no
problem - join Area Code to Area Code, Phone to Phone.

You may want to step back and consider "normalizing" your data -
having the same data in three tables is rarely good practice, and
there are better ways. If you'ld care to describe the nature of your
tables someone may be able to make some suggestions.