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.
 
Back
Top