Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Pivoted reports Expand / Collapse
Author
Message
Posted Thursday, September 12, 2013 5:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:23 PM
Points: 150, Visits: 392
I want my report to be pivoted.

my data

product - amt - month - Year
abc - 9.99 - 7 - 2013
abc - 39.99 - 7 - 2013
abc - 19.99 - 7 - 2013
abc - 5.99 - 8 - 2013
abc - 9.99 - 8 - 2013
abc - 29.99 - 8 - 2013
zzz - 7.99 - 7 - 2013
zzz - 19.99 - 7 - 2013
zzz - 9.99 - 7 - 2013
zzz - 13.99 - 8 - 2013
zzz - 17.99 - 8 - 2013
zzz - 59.99 - 8 - 2013


results I want in my report is this:

product - sumamt - month - Year - sumamt - month - year
abc - 70.00 - 7 - 2013 - 46.00 - 8 - 2013
zzz - 38.00 - 7 - 2013 - 92.00 - 8 - 2013



Post #1494093
Posted Thursday, September 12, 2013 9:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 5:29 PM
Points: 144, Visits: 522
An Access crosstab query will do some of what you are after, but it won't produce the format you are after as it only allows one column header. The pivot tools in Access are generally inferior to what you can do in Excel, so my suggestion would be to produce your report in Excel rather than Access. It's also important to know your version of Access as the tools vary depending on the version - some features have been removed in 2013 for example.

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
Post #1494242
Posted Thursday, September 12, 2013 9:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:23 PM
Points: 150, Visits: 392
my version is 2010


Post #1494253
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse