I have just started a new job where I am responsible for building and improving reports.
There is one report I am trying to move from Access to Crystal. The data is stored in an application called Acctivate. The previous person who held my job built the report with a series of queries that built multiple tables, and then a final query which aggregated the information from the tables built by the first five queries.
The PTB want the report in Crystal so the management for each client can call up their info and run the report, rather than have to call me and have me do it.
What is the best approach to this multi-level query (currently make-table) that will let me move the report out of Access?