troubleshooting Question

Formatting a Report in Access 2010

Avatar of doe5
doe5 asked on
Microsoft Access
10 Comments2 Solutions545 ViewsLast Modified:
I want to create a Report in Access 2010 the following format – I need to create a PDF to be emailed out:

                     For Pused=N                              For Pused=P                        For Pused=S
Prod       SumQty       SumPrice             SumQty    SumPrice             SumQty   SumPrice

I’m pulling from a temp table I created with the fields – Prod, SumQty, SumPrice, Pused – so I’ve already done the work on my data with a union query.  

I can’t figure out how to create the report with the data as above …. I can create a report with the information ‘vertically’ but it would be easier to read if displayed ‘horizontially’  

I’ve tried crosstab queries & subreport  but couldn’t  get it to work in the format I wanted.    The crosstab query would almost work but I could only have one sum or value field instead of two.
Join our community to see this answer!
Unlock 2 Answers and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros