Report results as Source?
3 March, 2015
Hello,
Is it possible to use the results of a report as the source for a new report?
I am creating a report for which I have a built a query that shows the min date for each customer ID. I then created an append query to which I connect the product name. (the results of these queries are shown in the image below. the results look good, however I need to aggregate the count of customers by product name (and show only the top 20 or 30 products). any idea how to do this?
Thanks,
Scott
Is it possible to use the results of a report as the source for a new report?
I am creating a report for which I have a built a query that shows the min date for each customer ID. I then created an append query to which I connect the product name. (the results of these queries are shown in the image below. the results look good, however I need to aggregate the count of customers by product name (and show only the top 20 or 30 products). any idea how to do this?
Thanks,
Scott
This query has been forwarded to Blacklight Solutions for initial handling and support. Client has been notified via email.