[AccessD] Crosstab query

Hi Jim,

I discovered that recently:

PIVOT column-headings-field IN(value1, value2, ...)

Regards, Philippe

2007/9/10, Jim Lawrence <accessd at shaw.ca>:
>
> Hi All:
>
> When creating a crosstab query is there a way to force a column for each
> day
> in a month even though there is no data for that date?
>
> I have experimented with adding a dummy record with name of 'zzz' and one
> item for each date of the particular month. It is functional but kludgy.
> There must be a better way.
>
> TIA
> Jim
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>