Preview / Print a Single Page Report for a group of data 2

[Fischercu]

Here’s my problem:
[ul]
[li]I am using a Microsoft Access database for one of our departments for data entry.[/li]
[li]They are taking forms that are completed by clients and inputting each form as a new data entry.[/li]
[li]The forms take information about where the client lives (counties inside our state), their income level, age group, and ethnic background. The client just fills in the number of people that fall into each of those categories, that live in the household. For example, if they have 2 Asian individuals living in their household, they would put a “2” in front of the “Asian” field on the form. See linked scan[/li]
[li]I then have a report, that tallies all of the data from every single form, and prints the numbers on the page. See linked image[/li][/ul]

My problem, is that it is doing a page for every single data entry when I run the report. I only want the first page of the report to show and print, because all I am doing, is taking the sum of each field in the data entry objects. For instance, in the Asian textbox, I have the following formula: =DSum([Asian])

How can I force the report to display only the first page, and more importantly have it print only the first page?

Thank you very much to everyone in advance for their help!

 

[dhookom]

I don't think you need a record source for your report if all your data values are coming from DSum() expressions.

I would create this report by using subreports rather than DSum()s which are slow and require maintenance. For instance, what happens if you want to include a new county? With DSum() I assume this suggests that you must add a new text box to your report. If you replaced your county text boxes with a subreport, this would be self-maintaining.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Fischercu]

Unfortunately, I am rather green when it comes to Access. If you have any websites, or information that I can research how to create these subreports to do what it is I am wanting to do, that would be very helpful.

Thanks!

 

[dhookom]

I may have started you off in a direction that might not be possible for you to do with your current data structure. Do you have separate fields for each county? If so, your problem is in the table structure and not the report. If your table structure works for you, then stay with it and continue to maintain your report as it is since adding a new county would probably involve adding a new field to a table.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Fischercu]

Yes, it is a separate field of each item.

I really don't mind which way I go about doing it, all I need is for it to work. So really, I can re-do the structure, or the report... whichever is easier. But, we already have data in the tables, that I would rather not have to re-input, as we are talking almost 500 forms from the people that come into our office.

 

[dhookom]

To get the number of Asians, set your table or query as the Record Source of the report and set the detail section to invisible. Open the Report Footer section to quite tall and add a text box with a control source of:
=Sum([Asian])
Do similar for other 'fields'.


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Fischercu]

EXCELLENT! Just moving it all to the Report Footer did it for me! I can't believe it was something so simple. Thanks for the help!