Orange County NC Website
Browse       Search
SYSTEM DESCRIPTION <br /> NR <br /> FUNCTIONAL DESCRIPTION <br /> Open the Query Wizard window by choosing New on the Edit Queries window. (See page 1-58.) <br /> MapTrak displays different Query Wizard windows depending on the type of query you select <br /> from the "Which type of query?"option buttons. Choosing a query type allows you to define how <br /> a query displays the resulting information. <br /> Subsequent Wizard windows. The Add command button becomes available when you select a <br /> field in the Fields scrolled list box. You can change the order of the fields in the Columns list box <br /> with the Up and Dn command buttons. <br /> The Ascending option button sorts the items in the list in ascending order(lowest to highest).The <br /> Descending option button sorts the items in the list in descending order(highest to lowest). <br /> An aggregate is a quantity relating to records in a query that you can include in the report, such as <br /> the total number of calls for each priority code or the average number of students in a school. <br /> When you complete the selection of values, a Finish buttons appears on the window. Choosing <br /> Finish closes the Query wizard and creates the query based on the data entered. You are returned <br /> to the Edit Queries window,which contains the data for the new theme. <br /> FIELDS AND BUTTONS <br /> Which type of <br /> query Three option buttons. Choose the option to use in the query. <br /> Regular Option button. Creates a column layout report displaying one row per <br /> record. <br /> Grouped. Option button. Creates a column layout report displaying grouped cate- <br /> gories combining into one row all the objects that share the same <br /> grouped field values. <br /> Cross Tab Option button. Creates a column layout report displaying all objects <br /> that share the same grouped field values combined into one cell. <br /> Read Only Check box. Select to make the query read only. <br /> Back Command button. Opens the previous query wizard window allowing you to <br /> change the selection of the value option. <br /> Next Command button.Opens the next query wizard window allowing you to select <br /> the next value options. <br /> 01/15/10 1-61 <br />