Re: Dynamic Column Headings Crosstab Report
Are you trying to ensure that missing headings are utilised in the column headings? Whereby if you are running a crosstab grouped by the month of a date and there is no data for a specific month and you still want that month to appear a blank column.
A cross tab query wil only give column heads for groupings that contain data. No data for July no July column.
Can you specify more?
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
The Home of Simple Software Solutions.
O/S Windows XP (SP3) & Windows 7 64bit
Access 2003 (version 11.0)
Access 2007 (version 12.0)
Remember when posting sample databases you will get a better response if it is pre Access 2007 - not all people have it installed.