linking tables

[Guest]

Our company has two plants each with their own scales (to weigh logging
trucks). I need to combine two tables to get a total weight delivered. I have
common fields in both tables: contractor, date delivered, & net weights. I
have done it with a report but would like to do this with a different
proccess so that I can add other information to my report. Thanks in advance
for any help!

 

[Guest]

you want to do an Append Query

to be safe - create a 3rd table with all the same fields (but no data)

then set up a query against table 1....don't filter anything out, include
all the fields - and set it up as an Append Query that is appending table 3.

(in Design View of the query - go to 'Query' in the menu bar and select
'Append Query' ....it will prompt you as to which Table you wish to append)

Repeat this with another Query against Table 2 that also appends table 3....

and your table 3 should then have both data.

you could skip one step by appending one to the other....but if you've never
done it before this 3rd table is a safer approach....