Create Union Query in Access 97

[Marie]

Could someone please give me an example of how to create a
union query using Access 97? I don't know if I've
forgotten how to do it or if it works differently in '97
than in later versions.

Thanks! -Marie

 

[david epsom dot com dot au]

Could someone please give me an example of how to create a

union query using Access 97? I don't know if I've

Open database
Goto Query tab
click on 'New'

Add one table/query from the 'show table' dialog
Close 'show table' dialog
Select fields from table/query

From menu, select View, SQL View.

At the end of the SQL, move the semi-colon,
add a new line, then type
union all

then continue with the next select statement.