Too Many Pages

I did a report that lists totals of criteria in a table. It should only be
one page with all of the totals. Instead, its 17 pages, and repeats the same
information over and over. How do have it only post this information one time?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11249-too-many-pages.html

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

The meaning of your question is unclear. What do you mean "criteria in a
table"? How are you attempting to obtain the totals?

"KB" wrote in message
news:A03E65BB-4E7D-49B3-820E-74A1A678F228@microsoft.com...
>I did a report that lists totals of criteria in a table. It should only be
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11249
> one page with all of the totals. Instead, its 17 pages, and repeats the
> same
> information over and over. How do have it only post this information one
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11249
> time?

Sorry. I have a table, with a column called "Bid Amount" (among other
columns), I made a query based on the columns in the table I needed, but the
critical one is "Bid Amount". In a report, I used the IIF function to count
the bid amounts based amount ranges ex:
=Sum(IIf([Bid Amount] >= 15000 And [Bid Amount] < 30000,1,0))
With many other dollar ranges, which fills 3/4 of a page. I set up start and
end dates for the report based on a date column in the table as well, but
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11249
that works fine. The problem is, if I click on the report, it asks for a
start date, I enter it, then it asks for an end date, and I enter that and
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11249
the report pulls up. If my start date is a month ago, it only displays 17
pages (the same report repeated over 17 pages). If my start date is two years
ago, its displays 310 pages of the same report repeated.


"BruceM" wrote:

> The meaning of your question is unclear. What do you mean "criteria in a
> table"? How are you attempting to obtain the totals?
>
> "KB" wrote in message
> news:A03E65BB-4E7D-49B3-820E-74A1A678F228@microsoft.com...
> >I did a report that lists totals of criteria in a table. It should only be
> > one page with all of the totals. Instead, its 17 pages, and repeats the
> > same
> > information over and over. How do have it only post this information one
> > time?
>
>
>

You don't say how you used the IIf expression, so let me make a suggestion.
Place the following in the Control Source of an unbound text box (I will
call it txtCounter) in the report detail section:
=IIf([Bid Amount] >= 15000 And [Bid Amount] < 30000,1,0)
You can set its Visible property to No.
Set its Running Sum property to Over All. In the Report footer, add an
unbound text box with its Control Source set to:
=[txtCounter]
Click View > Sorting and Grouping, and make sure you have not set up any
grouping levels.
If it is still not working, post details about your query (the one that asks
for the date range).

"KB" wrote in message
news:FC7BBAE4-139F-4654-995C-793ADA38245A@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11249
> Sorry. I have a table, with a column called "Bid Amount" (among other
> columns), I made a query based on the columns in the table I needed, but
> the
> critical one is "Bid Amount". In a report, I used the IIF function to
> count
> the bid amounts based amount ranges ex:
> =Sum(IIf([Bid Amount] >= 15000 And [Bid Amount] < 30000,1,0))
> With many other dollar ranges, which fills 3/4 of a page. I set up start
> and
> end dates for the report based on a date column in the table as well, but
> that works fine. The problem is, if I click on the report, it asks for a
> start date, I enter it, then it asks for an end date, and I enter that and
> the report pulls up. If my start date is a month ago, it only displays 17
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11249
> pages (the same report repeated over 17 pages). If my start date is two
> years
> ago, its displays 310 pages of the same report repeated.
>
>
> "BruceM" wrote:
>
>> The meaning of your question is unclear. What do you mean "criteria in a
>> table"? How are you attempting to obtain the totals?
>>
>> "KB" wrote in message
>> news:A03E65BB-4E7D-49B3-820E-74A1A678F228@microsoft.com...
>> >I did a report that lists totals of criteria in a table. It should only
>> >be
>> > one page with all of the totals. Instead, its 17 pages, and repeats the
>> > same
>> > information over and over. How do have it only post this information
>> > one
>> > time?
>>
>>
>>

The report is being printed for every row returned by the report's
RecordSource. What you have is a summary report bound to a detail record
set. Due to the way Access reports work, Access will print the detail
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11249
section of a report once for each record in the report's RecordSource.
Apparently your detail section fills an entire page, hence you get 17 pages.
One for each record.

You may be able to solve the problem by moving everything from the Detail
section to the Report Footer section.

"KB" wrote in message
news:A03E65BB-4E7D-49B3-820E-74A1A678F228@microsoft.com...
>I did a report that lists totals of criteria in a table. It should only be
> one page with all of the totals. Instead, its 17 pages, and repeats the
> same
> information over and over. How do have it only post this information one
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11249
> time?