Combined tables in Access!

[Gary B]

Hi,

I have 2 tables that are being updated by 2 seperate users at different sites

Table 1
ID
Site
Product
Date
Weight

Table 2
ID
Site
Product
Date
Weight

Both are recording data for their own site and have different product codes
in their respective tables. I thought, to keep things simple and reduce the
chance of a site entering the wrong products, I would allow them to enter the
data using a form with a combo drop down list with their unique product codes.

I now need to combine the data they are entering (now and going forward)

Any suggestions.

I'm sure I have missed something simple here!!

 

[Haris Rashid]

hi,

Use and append query to merge the records into one table.

In query Design view, click the arrow next to Query Type on the toolbar,
and then click Append. The Append dialog box appears.
In the Table Name box, enter the name of the table you want to append
records to.
Do one of the following:
If the table is in the currently open database, click Current Database.

If the table is not in the currently open database, click Another Database
and type the path of the database where the table is stored or click Browse
to locate the database.
Click OK.
Drag from the field list to the query design grid the fields you want to
append and any fields you want to use for setting criteria.

Regards,

 

[jacksonmacd]

If it's just for reporting purposes, you can use a UNION query, and
leave the tables intact. Furthermore, if you put this query in a
*third* database, you can link to the tables in the original two
databases, thus requiring no modifications to those databases
whatsoever.

SELECT * FROM Table1
UNION ALL
SELECT * FROM Table2

You must view the query in SQL view in order to create it -- Union
queries cannot be entered using the QBE grid. Also, Union queries are
read-only.

Hi,

I have 2 tables that are being updated by 2 seperate users at different sites

Table 1
ID
Site
Product
Date
Weight

Table 2
ID
Site
Product
Date
Weight

Both are recording data for their own site and have different product codes
in their respective tables. I thought, to keep things simple and reduce the
chance of a site entering the wrong products, I would allow them to enter the
data using a form with a combo drop down list with their unique product codes.

I now need to combine the data they are entering (now and going forward)

Any suggestions.

I'm sure I have missed something simple here!!

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security