gbpfan1231 Posted June 13, 2007 Share Posted June 13, 2007 Access Question: If I have a table/query that has the following: Org Product A 1 A 2 B 1 B 2 B 3 I would like a report to show that Org A sold 1,2 and Org B sold 1,2,3. I would like my result to be: Org Products A 1,2 B 1,2,3 Anyone know how to do this? Quote Link to comment Share on other sites More sharing options...
Big Country Posted June 13, 2007 Share Posted June 13, 2007 Depending on format you want, a crosstab query may work, if I am reading the question correctly, but CT Queries don't translate to reports well. One option would then be to export your table/query to Excel and do a Pivottable. Quote Link to comment Share on other sites More sharing options...
cre8tiff Posted June 13, 2007 Share Posted June 13, 2007 get a real database. Quote Link to comment Share on other sites More sharing options...
gbpfan1231 Posted June 13, 2007 Author Share Posted June 13, 2007 Depending on format you want, a crosstab query may work, if I am reading the question correctly, but CT Queries don't translate to reports well. One option would then be to export your table/query to Excel and do a Pivottable. This seemed to do the trick. Thanks man!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.