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.