Hi all,
Searched for this one and saw that similar issues had subreports with a one-to-many relationship of tables in the queries.
My query has a single table with 900 records. It has an underlying many-to-one relationship with another table that is not referenced in this query or report.
The report is set up to essentially do frequencies and percentages. So, I have entered the function Sum(IIf([MyField]=1,1,0)) into the report text box for the frequency (for each variable of interest). This then results in 900 pages of the same report.
Is there a quick fix to get a single page of these frequencies, or do I need to place these functions into a query and work from there (where I am then limited to 255 calculations)?
Many thanks!
Lori
Searched for this one and saw that similar issues had subreports with a one-to-many relationship of tables in the queries.
My query has a single table with 900 records. It has an underlying many-to-one relationship with another table that is not referenced in this query or report.
The report is set up to essentially do frequencies and percentages. So, I have entered the function Sum(IIf([MyField]=1,1,0)) into the report text box for the frequency (for each variable of interest). This then results in 900 pages of the same report.
Is there a quick fix to get a single page of these frequencies, or do I need to place these functions into a query and work from there (where I am then limited to 255 calculations)?
Many thanks!
Lori
