Reducing the Amount of Data in a Database Summary

Another way to reduce the amount of stored data is to use a Where Clause to narrow selection criteria. This is also done through the Data View Definition dialog box, which is accessed from the Configuration tab of the Database Summary properties dialog. Double-click on the required record to open the Data View Definition dialog box.

Once the Data View Definition dialog box has opened, select the Where Clause tab. If a Where Clause already exists it can be changed, for example BUSY>0 could be changed to BUSY>25, thereby only data that matches the 'Busy Percent' of 25 or greater will be stored. If a Where Clause does not already exist a new one can be added.

See Where Clauses for further information.

Provide feedback on this article