[AccessD] Crosstab query

You can define what fields you want in the Query Properties "Column 
Headings".

Good luck,

Mark A. Matte


>From: Jim Lawrence <accessd at shaw.ca>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: [AccessD] Crosstab query
>Date: Mon, 10 Sep 2007 00:30:31 -0700
>
>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

_________________________________________________________________
A place for moms to take a break! 
http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us