Windows 7 64bit 
Access 2010 64bit
I have a main report based on a simple query that gives me a list of names that have transactions associated with them, removing the duplicate entries. Inside that report, I am trying to run 3 other sub reports linked to each name generated by the main report that will give me columned data by month based on different querys. Each of the sub reports runs fine as standalone reports. However, when inserted into the main report, it keeps asking for the parameter values. I now am only working with one sub report trying to get that part to work and it still keeps asking for the parameter values. The link (parent/child) settings are the same (name/name).
What I am trying to build is a project/job/contract Profit and Loss report, with monthly columns, annual total column, budget and variance columns. The main report gives me the list of active projects and the three sub reports are (Income, Cogs, Expenses). Quires are already built for each sub report and they works fine when run by themselves. I just need to combine the three reports and total them.
Based on the forums, I tried to 'group' the active project names and put the sub report in the group footer. That did not work. I am not using a form to input data, just a report with sub reports. As I built the query’s from linked tables, I cannot even move the database file without bringing the entire accounting file. I have supplied screen shots (inside zipped power point) of each sub report design view and each query design view.
Right now the main report is blank with just the active project report as the starting point. Any guidence would be appreciated.
Reply With Quote
