You can use the Replace Formula dialog box to select another formula to replace the current one in a query. This topic describes the options in the dialog box.
Designer displays the Replace Formula dialog box when you double-click any formula that you add to be the column of a query in the Query Editor dialog box.
You see the following options in the dialog box:
This box lists all the available formulas that you can use as query columns. Select the formula you want to use to replace the current one.
This box shows the expression of the selected formula.
Select to replace the current formula with the specified one in the Formulas box.
Select to close the dialog box.
Select to view information about the dialog box.