[AccessD] Crosstab query

Jim Lawrence accessd at shaw.ca
Mon Sep 10 02:30:31 CDT 2007


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  




More information about the AccessD mailing list