Query to merge fields?

[dgmorr]

Hey guys,

I'm in need of some help again. I have two tables, Table1 and Table2. I have one field in each table that I want to have the same data. I don't want blanks to be merged, but I want all the data to be the same

for example

Table1
---------
1

3

5

Table2
---------
1
2

4

6


I would like both tables to be merged to show

Table1
-------
1
2
3
4
5
6

Table2
------
1
2
3
4
5
6

But I want to just update both tables and not create anything new.

Sorry if this is unclear

 

[neileg]

Sorry if this is unclear

Sorry, it is.

 

[GaryPanic]

Quick question
why have 2 tables
just export both tables into a new one
otherwise you'll have a real mess
as 1 table might get updated and the other one would not

- make a copy of your d/b
work on this.
make table qry on table1
create table xxxxxxxxxxxxxxx
table2 append qry to XXXXXXXXXXXXXXXXXX

this should freakout on the duplicates - but should leave you with what you are after

No idea why you want to do this