Create Union Query in Access 97

  • Thread starter Thread starter Marie
  • Start date Start date
M

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
 
Could someone please give me an example of how to create a
union query using Access 97? I don't know if I've
Click to expand...

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