Access Macros

[George L]

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?

 

[Guest]

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.

 

[Steve Schapel]

George.

A Union Query may be what you are looking for here.