I have a long survey (how long til I finish this wretched thing? weep, sob) for which I’ve had to show results in 3 reports because of the limit on the number of controls you can have in one report.
Each report uses as it’s control source a single table called Survey Results which contains answers for all questions on the whole survey. When I run the reports, they have the correct information, but they repeat the pages 3 times (in sequence 1,2,3,1,2,3 etc.)
I thought maybe it was becauseI should break the control source into the 3rds of the reports actually covered in each report. I did that by creating 3 queries with the survey # and approp. fields. Then I changed the control source for the 1st report to query one, but there wasno change. Any help would be appreciated.