Jspenceratty: Created page with " – The form allows you to change data in tables, such as Clients or Eligibility, based upon the set of criteria you set. It is an alternative to an Update Query. 1) Choose..."

2017-11-28T16:46:41Z

Created page with " – The form allows you to change data in tables, such as Clients or Eligibility, based upon the set of criteria you set. It is an alternative to an Update Query. 1) Choose..."

New page

– The form allows you to change data in tables, such as Clients or Eligibility, based upon the set of criteria you set. It is an alternative to an Update Query.
1) Choose a Table tab – Choose which table you want to make changes to

[[File:UT7.png|thumb|none]]

2) Choose Fields to be Updated – Go to the next tab and Choose the fields where you would like to change the data

[[File:UT8.png|thumb|none]]

3) List Fields with New Values – On the next tab, Review the list of fields with the new values to ensure they are the ones you want to update and what you want to update them to is correct also. If all is correct, click the Set Updates button

[[File:UT9.png|thumb|none]]

4) Set Criteria Run the Update – Go to this last tab to Set the criteria that determine which records get changed. Then generate the query by clicking Make Query. You will see the query language in the box. Review it to see the data that will be changed

[[File:UT10.png|thumb|none]]

5) Then Run the Global Change to change the selected data.

Global Change Form - Revision history

Jspenceratty: Created page with " – The form allows you to change data in tables, such as Clients or Eligibility, based upon the set of criteria you set. It is an alternative to an Update Query. 1) Choose..."