How Much Formula Does Wic Provide In Canada?

Add and reorder the fields


To add fields to the grid can:

* Double-click the field name that appears in the table, this will be placed in the first column of the grid free.

* Click on the name of the field that appears in the table and hold the mouse button, drag the field onto the grid, release the button when over the column before which you want to leave the field we're adding .

* Click on the Field row: a column empty grid appears on the right arrow to display a list of all fields from all tables in the tables area. If we many fields and multiple tables can reduce the list by first selecting a table in the Table row, and the drop-down fields only appear in the selected table.

* We can also directly type the field name in the Field row: from an empty column of the grid.

* If you want all the fields in the table appearing on the outcome of the consultation we can use the asterisk * (synonymous with 'all fields'). Define


calculated fields: Calculated fields are fields obtained from the result of an expression or function.


column headers can

change the header of the columns in the query result.

usually appears in the header of the column the name of the column, if we change the header as indicated in the row field: Type the name of the field ahead and followed by a colon (:). It is used mostly for calculated fields.


Change the order of the fields

If we include fields in the grid and want to change the order of these fields can move a column (or several) dragging or cutting and pasting.


To move a column by dragging: Position the cursor over the top of the column and when aparece la flecha hacer clic, la columna aparecerá resaltada (está seleccionada). Mover un poco el cursor para que aparezca la flecha. Pulsar el botón del ratón y sin soltarlo arrastrar la columna hasta la posición deseada.

Para mover una columna cortándola: Seleccionar la columna (posicionar el cursor sobre el extremo superior de la columna y cuando aparece la flecha hacer clic). Hacer clic sobre el icono en la pestaña Inicio (o bien teclear Ctrl+X), desaparecerá la columna.

A continuación crear una columna en blanco en el lugar donde queremos mover la columna que hemos cortado con la opción Insertar Columnas de la pestaña Diseño.

Seleccionar that column and click the Paste icon on the Home tab (or hit Ctrl + V).

can select multiple columns by selecting the first row and holding down the Shift key, select the last column to select, we will select the two columns and all columns that are between the two.