Adding fields into exisiting table

[tekari]

Hi all,

I have one Master Table that has Age, Date, and Order. I also have
another table that comes each month with the same fields.

Is there any way using a query or whatever that I can take that second
table and append just the "order" field onto the end of the Master
Table.

The other problem with this is, occasionally there will be records in
the new table that are brand new and not in the master table. So if
they didn't appear in the master table it would need to enter the
whole row in plus a blank order number and then the real order number.

As an example....

If this is the master table:

Age: Date: Order
10 1.1.07 1234
11 1.2.07 4321


And this is the new table:

Age: Date: Order
10 1.1.07 1111
11 1.2.07 5555
15 1.2.07 9999

The combined table should be like:

Age: Date: Order Order2
10 1.1.07 1234 1111
11 1.2.07 4321 5555
15 1.2.07 9999

And so on....

Thanks for any help!!

 

[Duane Hookom]

Do you have a good reason for creating an un-normalized table structure? I
would append the records so you would end up with a table like:

Age: Date: Order OrderNum
10 1.1.07 1234 1
11 1.2.07 4321 1
10 1.1.07 1111 2
11 1.2.07 5555 2
15 1.2.07 9999 2

You can then create a crosstab query that create different order number
columns (if needed).