View Full Version : Combining Two Lists


chrisrobbo
06-02-2002, 12:45 PM
How can I combine indentical fields in two tables with a query. To be used in a combo box.

llkhoutx
06-02-2002, 01:17 PM
Use a union query, that is,

Select AField from TableA
Union
Select AnotherField from TableB;

AField and AnotherField should be of the same data type.

Of course, you can select mutliple fields.