Search results

I will try a union query as soon as I get my underlying queries straightened out. So far I have: Query1: SELECT [Key Activists Statewide Again].Region, [Key Activists Statewide Again].County, [Key Activists Statewide Again].Precinct, Count([Key Activists Statewide Again].County) AS [Number...

Yeah I can try to do it with subreports, but the formatting problems are just crazy. I figured it would be easier to do it through queries, but I guess not.

No, I think the only way to get it done is to make three Totals queries to get the Sums for different fields, using different grouping --one for activists per precinct and one for households per precinct -- and then link the totals queries to the main table or query, by ID. Then the resulting...

That is why this report is so complicated. I already have grouping levels: Region County Precinct #ofactivists #ofhouseholds #w/phone 1 Suffolk Suffolk1 37 32 30 Suffolk 2 40 39...

I am summing the fields in the report to get totals on the bottom, but I need the columns to display the counts of people grouped by precinct, which is different than total. The problem is that I only need the last two columns to come from distinct households....so how do I make only those...

I am working on a report in access 2002 that needs to look like this: Region County Precinct #ofActivists #ofHouseholds HouseholdswithPhones This is tricky because the NumberofActivists column needs to return the total number of activists grouped by precinct while the last two columns need...