Defines a name and optional parameters.

Note: The PROCEDURE clause has been superseded by the PROCEDURE statement. Although the PROCEDURE clause is still supported, the PROCEDURE statement provides a superset of the capability of the PROCEDURE clause and is the recommended syntax.


PROCEDURE name [param1 datatype[, param2 datatype[, ...]]

The PROCEDURE clause has these parts:




A name for the procedure.

param1, param2

One or more field names or parameters. For example:

PROCEDURE Sales_By_CountryRegion [Beginning Date] DateTime, [Ending Date] DateTime;


One of the primary Microsoft Access SQL data types or their synonyms.


An SQL procedure consists of a PROCEDURE clause (which specifies the name of the procedure), an optional list of parameter definitions, and a single SQL statement. For example, the procedure Get_Part_Number might run a query that retrieves a specified part number.


  • If the clause includes more than one field definition (that is, param-datatype pairs), separate them with commas.

  • The PROCEDURE clause must be followed by an SQL statement (for example, a SELECT or UPDATE statement).

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.