Include user-defined functions in a query (ADP)

In the Database window, click Queries under Objects, click the query you want to open, and then click Design on the database window toolbar.
Design the query to which you want to add the function. In the Query Designer, be sure the Diagram pane is visible.
From the list of functions, drag the function onto the Diagram pane.

In the Database window, click Queries under Objects, click the query you want to open, and then click Design on the database window toolbar.
Design the query to which you want to add the function. In the Query Designer, be sure the Grid pane is visible.
In the first blank row of the Grid pane, enter the name of the function in the Column column.