I created a database to analyze test results. There is a text field for each question number, total of 64 numbers. Each question number has a combo box with 4 choices: correct, partially correct, wrong, and blank. After entering all the test results, I created a report with text boxes for each of the 4 choices for all 64 questions. Each text box has a DCount expression in the control to total each of the 4 choices. When I preview the report, all the calculated fields work fine and appear on the first two pages, but the same results keeps repeating page after page for 232 pages! Any idea about how to get it down to just the two pages? Thanks for any help!
Repeating Report Pages
- Thread starter rntkid
- Start date
wazz
Super Moderator
- Local time
- Tomorrow, 04:00
- Joined
- Jun 29, 2004
- Messages
- 1,702
depends on how you set things up. you might fix it by playing with 'groupings' - check the menu under 'view' if the button isn't on your toolbar. could be something else and we might need to see your query for the report. (use a query if you aren't and see if it works by itself...).
Hi Pat,
I didn't know how to post the record source query, so I whittled down the database to the bare bones in order to be able to attach it. I deleted most of the records, which has pared the report down to 20 pages instead of 232.
Many thanks for taking a look at it!
rntkid
I didn't know how to post the record source query, so I whittled down the database to the bare bones in order to be able to attach it. I deleted most of the records, which has pared the report down to 20 pages instead of 232.
Many thanks for taking a look at it!
rntkid
Hi Pat,
Using the qryAllResults as the record source was indeed the problem. The control source DCount expressions in all the report text boxes that reference the query work fine without the query as the record source. Now my report is down to the two pages it's supposed to be!! I need to keep the query, however, because I will be using various criteria in it to filter the results for other reports. THANK YOU SO MUCH FOR YOUR HELP!
Very gratefully,
rntkid
Using the qryAllResults as the record source was indeed the problem. The control source DCount expressions in all the report text boxes that reference the query work fine without the query as the record source. Now my report is down to the two pages it's supposed to be!! I need to keep the query, however, because I will be using various criteria in it to filter the results for other reports. THANK YOU SO MUCH FOR YOUR HELP!
Very gratefully,
rntkid
