...
- Find the query "Closeout Query."
- Right click on it and open it in design view.
- Ensure that it's does not have an Update to line:
Clicking on the Select button in the menu removes the Update line. Clicking on the Update button in the menu adds it back - Run an update query to change the status of current Rejected orders to the new status for the fiscal year just ending.
- First find all status 4 orders without doing the update. Fill 4 into the criteria line in the query. Right click on it in the left menu and select open. You should see a bunch of status 8's but nothing else.
- Go back to design view by right clicking on it in the left menu and selecting design view.
- Click the update button in the top menu
- Enter the value you want the 4's to change to into the update line
- Right click on the query in the side menu and select "Open."click the run! button in the top menu.
- Run an update query to change the status of the current Cleared in Acquisitions orders to the new status for the fiscal year just ending.
- Right click on it and open it in design view.
- Ensure that it's does not have an Update to line:
- First find all status 8 order without doing the update. Fill 8 into the criteria line in the query. Right click on it in the left menu and select open. You should see a bunch of status 8's but nothing else.
- Go back to design view by right clicking on it in the left menu and selecting design view.
- Click the update button in the top menu
- Enter the value you want the 8's to change to into the update line
- Right click on the query in the side menu and
- click the run! button in the top menu.
Adjust the web interface and restore access:
...