I have a report that is based on a query.
The report shows total applications per county, total records per county and total dollars.
The problem is that if I want to show only the total application per county I have to use a separate query and group by the app number. This works beatifully for a report that has all 16 counties and a total of all apps for the 16 counties.
But,
The user wants to be able choose 2 or 3 counties and show the same report for those counties.
So, I can get the report to show all the field for the chosen counties but the and I can show the total apps from the second query for the chosen counties. But I can't sum the total apps from the chosen counties from the query. It just errors.......I think because the 2nd query is not the active query.
So, my thinking is that I ought to be able to add the chosen counties app total right from the report since they are accurate. Is there a way to do this? Thanks, Greg
The report shows total applications per county, total records per county and total dollars.
The problem is that if I want to show only the total application per county I have to use a separate query and group by the app number. This works beatifully for a report that has all 16 counties and a total of all apps for the 16 counties.
But,
The user wants to be able choose 2 or 3 counties and show the same report for those counties.
So, I can get the report to show all the field for the chosen counties but the and I can show the total apps from the second query for the chosen counties. But I can't sum the total apps from the chosen counties from the query. It just errors.......I think because the 2nd query is not the active query.
So, my thinking is that I ought to be able to add the chosen counties app total right from the report since they are accurate. Is there a way to do this? Thanks, Greg