ewaldt at gdls.com
ewaldt at gdls.com
Wed Nov 15 11:13:23 CST 2006
Yup, just like with months, days of the week, etc. I just couldn't remember how to do it; it had been a long time since I'd needed to do so. Thanks for your help. Thomas F. Ewald FCS Database Manager General Dynamics Land Systems (586) 276-1256 "Heenan, Lambert" <Lambert.Heenan at AIG.com> 11/15/2006 10:22 AM To "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> cc "'ewaldt at gdls.com'" <ewaldt at gdls.com> Subject RE: [AccessD] Filling in the CrossTab Help Request Sure. Open the Crosstab query in design mode. On the property sheet you will find a "Column Headings" property. Just fill this with a list of your columns ... "Qtr 1", "Qtr 2", "Qtr 3", "Qtr 4" ... then you will always have all columns reported, and in the order you specify. HTH Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of ewaldt at gdls.com Sent: Wednesday, November 15, 2006 9:59 AM To: accessd at databaseadvisors.com Subject: [AccessD] Filling in the CrossTab Help Request I have a table with steps numbering 1 to 24; those numbers are shown as column headers in the crosstab. My crosstab only shows those columns for which there is data, of course. Is there a way to adapt it to show all 24 numbers, even if the columns are empty of data? TIA. Thomas F. Ewald FCS Database Manager General Dynamics Land Systems (586) 276-1256 This is an e-mail from General Dynamics Land Systems. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This is an e-mail from General Dynamics Land Systems. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.