Example: columns sort date jan 2010, Jan 2011, Jan 2012
I want Jan 2010, February 2010, March 2010
Advanced Beginner
Windows XP 
Access 2010 32bit
Example: columns sort date jan 2010, Jan 2011, Jan 2012
I want Jan 2010, February 2010, March 2010
VIP
Windows 7 64bit Access 2010 32bit
You will have to calculate a field that formats the date as YYYYMM and use that field as Column Header.
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.
Advanced Beginner
Windows XP Access 2010 32bit
I changed the format but it changed the date to Microsoft numerical date versus 2012Jun
VIP
Windows 7 64bit Access 2010 32bit
Show the SQL statement of attempted query.
Format([fieldname],"yyyymm")
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.
Advanced Beginner
Windows XP Access 2010 32bit
Expr3: Format([Datepaid],"yyyymm")
VIP
Windows 7 64bit Access 2010 32bit
Format results in a string. I have used this before in CROSSTAB and never had the issue you describe.
That is not the complete SQL statement.
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.
Create month end date, from Month(Numberic) and Year(Numeric)
month year date
Sort by date and year
Posting Permissions
Reply With Quote