Date field (Cross Table Wizard - Step 3)
Column or Row
If you move a date field in the Cross Table Wizard Step 3 to the columns or rows location, you will be prompt to select a level for that field, displayed in the following dialog box:
By default the Group Field will apply to the entire value, but you can ask to group the field by year, quarter, month, or day of month (default is Value). You can add several levels, for example a first level on the year, then a level on the quarter, then a level on the month.
Note the <Delete> button that can be used to remove the field in the Column or Row areas. You can also press the <Del> key to remove a field in these areas.
Data
If you move a date field in the Cross Table Wizard Step 3 to the data location, a CountVal function is applied by default to that date field. You can then, if necessary, make a double click on that field to display the Group Field dialog box and modify the function to another:
For a date field the following functions can be applied:
The Minimum value for that field: the oldest date.
The Maximum value for that field: the more recent date.
The CountVal value for that field: the number of not null occurrence for the field.
The Count(*) value for that field: the total number of occurrence for the field, including null values.
Note the <Delete> button that can be used to remove the field in the Data area. You can also press the <Del> key to remove a field in this area.