Novice
Windows 8 
Access 2010 64bit
Morning,
I have a textbox called [production week] in the same names group header in the report. All I want to know is how to set this so that in the report the production weeks are displayed in columns (to the right) and not below each other as is the default. I am using access 2010
Any help would be appreciated
Richard
VIP
Windows 7 64bit Access 2010 32bit
That is a CROSSTAB query. Building report based on CROSSTAB to run perpetually is not easy because of the dynamic field headings, especially for dates.
Search forum or web on dynamic crosstab report. http://allenbrowne.com/ser-67.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Converting Rows to Columns and Columns to Rows
Group By Query - no zero values in the output
Posting Permissions
Reply With Quote