Need Help On Macro

[Andrew Chappell]

Let me try to explain this:
I have a list of names in a database table and a list of names in a
different database table. I am trying to create a macro that will find
all of the names from table 1 in table 2.


Basically:
-Table 1 Names
-Compared to
-Table 2 Names
-And find all matches


I've never done a macro before but after looking at Microsoft Access,
it doesnt look that hard. If anyone could walk me through what I need
to do, it would be a great deal of help

 

[Allen Browne]

Andrew, would you be happy to do this in a query rather than a macro?

Create a query, using both tables.
In the upper pane of query design, drag the Names field from Table1 and drop
it onto the Names field in Table2.

The query will output only the matching names.

If you want those that don't match, use the Unmatched Query Wizard.
(It's the last option in the first dialog when you create a new query.)

 

[Guest]

Hi Andrew,

What you really want to do is create a query...

If you start a new query using the query wizard you will find that there is
a "Find Duplicates" query wizard that will do what you are after.

Damian.

 

[Andrew Chappell]

Awesome, thanks guys. I'll try this out, really appreciate the help

-Andrew Chappell