This is very helpful and exactly what I'm looking to do, but can you please explain how to adjust the query (or set up the report) so that I can re-create it for future use (I need to run the report monthly based on updated data). Thanks again for your time and help!
Thank you SO much! here is a pdf of the exact way I want the graph to look - I was able to do it in Excel, but it takes some finagling, and I would prefer to do it programmatically in Access! Again, thanks for your help!
Hi JHB, I hope you get an alert that I'm posting this since it's quite a while since the original post. Anyway - the combined clustered / stacked graph you posted in your picture is exactly what I need to do with my data. Can you please advise on how to do that? Basically, I have research data...