OK. Here's where I got to (Sequence) Objects, Queries,
New, New Query Dialog box, Design View, Close Show Table,
Query, SQL Specific, Union. Then a blank box appears, but
there is no place on the menu from which to draw SQL
server statements, nor can I access any fields. Now what?
Well... you need to know some SQL. (It's not SQL/Server by the way -
SQL was a language standard before Microsoft ever heard of it, and
both Access and SQL/Server are products which use their own version of
that standard).
The simplest way would be to create a query in the query grid using
one of the tables that you want to include in your UNION query. (Since
I don't know your table structure I can't advise). Use the View menu
option or the query design tool in the toolbar to switch to SQL view;
you'll see something vaguely like
SELECT this, that, theother FROM mytable...
Use copy and paste to make multiple copies of this separated by the
keyword UNION (to exclude duplicate records) or, more likely for this
case, UNION ALL (to allow duplicate records - it'll run faster if
there are none to be excluded). You'll end up with something like
SELECT this, that, theother FROM mytable
UNION ALL
SELECT this, that, theother FROM anothertable
UNION ALL
SELECT this, that, theother FROM yetadifferenttable
The fieldnames don't need to be the same, but there must be the same
number of fields, and they must be of matching datatypes, in each
SELECT clause.
