[AccessD] Crosstab query

Thanks Andy; that looks like it will work and now I have 2 excellent
methods. Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Monday, September 10, 2007 1:35 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Crosstab query

Hi Jim
What I've done on occasions is have a dummy table with, in your case, just
all of the day numbers or dates and Left Join from your data to that.

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: "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: 10/09/07 07:29


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

________________________________________________
Message sent using UebiMiau 2.7.2

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com