Software

Ask something
Discussion Locked

Access 97 Report making triplicate pages

0 helpful
3 replies

by learneverything

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by melodyj

I had a problem like that once. I never figured out what the true problem was, but we worked around it by only printing 50 pages at a time (we were printing a 400 page report).

Regards,
Melody

by learneverything

I finally figured it out. It had nothing to do with having 3 reports. It was because there were 3 sample reports entered and the fields were in the details section. Duh!

This discussion is closed to new replies.