Andy Lacey
andy at minstersystems.co.uk
Mon Sep 10 03:35:23 CDT 2007
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