Hi,
It is just that
PIVOT expression
and you can optionally supply a list of values you wish to consider for the
expression, in a IN list:
PIVOT expression IN( list )
The expression can be a field, a combination of fields, or even a VBA
expression. Each value ( only those in the list, if a list is supplied) of
the expression will create a field in the output, with that value for name
of the field.
Hoping it may help,
Vanderghast, Access MVP
