[AccessD] Crosstab query

Thanks Philippe, this looks like an excellent method. Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of philippe pons
Sent: Monday, September 10, 2007 12:40 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com