Combining 2 fields into one

[Guest]

I have 2 databases with 2 tables named "ShipAddress", I linked one table to
one of the databases and becomes "ShipAddress1". On both tables there is a
field name "ShipName". I need on a form on datasheet view to show on 1 field
the "ShipName" from both tables

 

[Ken Snell \(MVP\)]

A union query will do this for you:

SELECT ShipAddress.ShipName
FROM ShipAddress
UNION
SELECT ShipAddress1.ShipName
FROM ShipAddress1;

 

[Guest]

It worked!

Thank you for your help

A union query will do this for you:

SELECT ShipAddress.ShipName
FROM ShipAddress
UNION
SELECT ShipAddress1.ShipName
FROM ShipAddress1;