[AccessD] Crosstab query

Charlotte Foust cfoust at infostatsystems.com
Mon Sep 10 10:47:38 CDT 2007


Just set the column headings for the query, i.e., 1,2,3,4 ...31.  

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Monday, September 10, 2007 12:31 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Crosstab query

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




More information about the AccessD mailing list