var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Create Report based on the query pivottable view
Is it possible to create a report in access same as pivot table view of a query? I would like to create a report same as my pivot table view of a qery.
Can anyone help me in solving this problem?
If a pivot report doesn't do it then I have no idea. I never use pivots though, so I'm not that much help here
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!
"Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "
I embed a sub-report and then base that sub-report off of a crosstab query.
There's an example here: http://www.dbforums.com/6303905-post54.html
and here: http://www.dbforums.com/6390529-post84.html
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)