How can I combine indentical fields in two tables with a query. To be used in a combo box.
C chrisrobbo Guest Jun 2, 2002 #1 How can I combine indentical fields in two tables with a query. To be used in a combo box.
L llkhoutx Registered User. Local time Today, 00:29 Joined Feb 26, 2001 Messages 4,018 Jun 2, 2002 #2 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.
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.