Feedback

  • Contents
 

Create an Account Status Change Query

Use the Status Changer window to create a query for changing the status of a group of accounts that meet specified criteria. 

To create an account status change query

  1. In the Main Menu window, from the Tools menu, click Status Changer. The Status Changer window appears.

Status Changer window

  1. In the Conditions pane, do the following as necessary:

  1. In the Order pane, do the steps to Specify the Sort Order for Query Results.

  2. To count the number of records that match the selection criteria, in the toolbar, click Count. The results appear in the Query Designer dialog box. Click OK.

  3. To save the query, do the following:

    1. In the toolbar, click Save. The Save Query Dialog box appears.

Save Query Dialog box

    1. In the Query Name box, type a name for the query and then click Save.

Tip: To overwrite an existing query, in the Name column, click the query to overwrite and then click Save.

  1. To run the query to change the status of accounts, do the steps to Change the Status of a Group of Accounts.

Related Topics

Status Changer