• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Working with Structured Quer... > Writing Action and Crosstab Queries

Writing Action and Crosstab Queries

Data Manipulation Language (DML) commands are implemented by Access's action queries: append, delete, make-table, and update. Jet SQL reserved words that create crosstab queries—TRANSFORM and PIVOT—are included in this section because crosstab queries are related to DML queries. This sections shows the syntax for each type of Access action query.

Append queries use the following syntax:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint