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