As you select fields, make sure that you add the same number of fields, in the same order, that you add to the other select queries. In the query design window, double-click each of the fields that you want to include. The table is added to the query design window. On the Create tab, in the Queries group, click Query Design.ĭouble-click the table that has the fields that you want to include. If you'd like to skip reading the steps and instead watch an example, see the next section, Watch an example of building a union query.

You can then copy and paste the SQL parts into a combined union query. Create a union query by creating and combining select queriesĮven though you can create a union query by directly writing the SQL syntax in the SQL view, you might find it easier to build it in parts with select queries.

Note: Union queries are always read-only in Access you can't change any values in datasheet view. In this illustration, we've added some extra spacing in the SQL so you can easily see the various parts that make up a union query. To continue your study of this union query example, click Home > Views > SQL View to view the SQL syntax that defines it. You can only switch between Datasheet View and SQL View when working with union queries. Under the Views command on the Home tab, you'll notice that Design View is not available when you work with union queries. You’ll experience this if you open a union query from the Navigation Pane Access opens it and display the results in datasheet view. Unlike normal select and action queries, tables are not related in a union query, which means the Access graphic query designer can't be used to build or edit union queries. Union queries are easy to differentiate from other query objects because they have a special icon that resembles two intertwined circles representing a united set from two sets: Next, expand the Queries group and you'll see a query called Product Transactions. Click the top of the Navigation Pane and then select Object Type to organize all the database objects by their type. You can search for the Northwind sample template on the getting started page of Access by clicking File > New or you can directly download a copy from this location: Northwind sample template.Īfter Access opens the Northwind database, dismiss the login dialog form that first appears and then expand the Navigation Pane. If you've never created a union query before, you might find it useful to first study a working example in the Northwind Access template. You can't create or use a union query in Access web databases or Access web apps. Note: The content in this article is intended for use with Access desktop databases.

Acoustica 7 union keyqword