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.
|
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. |