Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Too Many Pages

Discussion in 'Information Technology' started by KB, Jul 28, 2006.

Tags:
  1. KB

    KB
    Expand Collapse
    Guest

    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?
     
  2. Loading...

    Similar Threads Forum Date
    The Problem with Taking Too Many Vitamins Health & Nutrition Oct 18, 2013
    Too Many Hukamnamas! Questions and Answers Jun 13, 2012
    One Drink Too Many? A Discussion of Alcohol and Sikhi Sikh Sikhi Sikhism Jul 6, 2011
    Christianity After Blast in Egypt, Many Deride Their Church as Too Timid Interfaith Dialogues Jan 9, 2011
    Legal The Other Half: Too Many Lacunae Breaking News Dec 27, 2010

  3. BruceM

    BruceM
    Expand Collapse
    Guest

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

    "KB" <KB@discussions.microsoft.com> 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?
     
  4. KB

    KB
    Expand Collapse
    Guest

    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
    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" <KB@discussions.microsoft.com> 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?

    >
    >
    >
     
  5. BruceM

    BruceM
    Expand Collapse
    Guest

    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" <KB@discussions.microsoft.com> wrote in message
    news:FC7BBAE4-139F-4654-995C-793ADA38245A@microsoft.com...
    > 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
    > 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" <KB@discussions.microsoft.com> 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?

    >>
    >>
    >>
     
  6. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    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
    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" <KB@discussions.microsoft.com> 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?
     

Share This Page