Access Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to pull information from 2 tables and summarise it into one table.
I've tried a query linking the common feild, however, only the common records
appear in the new table. Is it possible to use a queery or a Macro to pull
the information from two tables together which includes all records from both
tables?
 
hi,
not really. an inner join would only select records that
would be common to both tables, leaving out the rest.
a left join would select all records in one table but
would only select matching records in the other table.
in your case i would copy one table the write an append
query which would append all of the second table to the
copy of the first table.
good luck.
 
George.

A Union Query may be what you are looking for here.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro fails from button, runs when selected directly 5
Record Macros in Access 2003? 1
How to export table from outlook into ms access table? 0
Run a macro and pause before running second macro 1
Access Dcount (multiple criteria) 3
Need Macro to run cross tab query and export to access table 2
Export table to txt file with a variable filename 0
SendObject Macro 10

Back
Top