Welcome to SPN

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

Sign Up Now!

Line Items Scrambling in Report

Discussion in 'Information Technology' started by PipeMan, Nov 18, 2005.

  1. PipeMan

    PipeMan
    Expand Collapse
    Guest

    Please help -

    I have report called Quotations based on a Form called QuoteForm. Line
    Items are entered into QuoteForm using a sub-form called QuoteDetails. The
    Report is layed out so that the line items in the QuoteDetails match in the
    Report. However, sometimes the line items get scrambled. I do have a
    LineItemID and the query that QuoteDetails is based, is sorted by the
    LineItemID. I'm not sure why this happens, but it normally happens after we
    Compact/Repair the database.

    Thanks in advance,

    Greg Pardue
     
  2. Loading...

    Similar Threads Forum Date
    Khalsa Aid The Selfless Sikh Faith On The Frontline, A Documentary By BBC 2016 Sikh Organisations Nov 16, 2016
    Sikh News Veteran Sikh Soldiers To Inspire Young - Malay Mail Online Breaking News Aug 1, 2016
    Hard Talk Confused Islamophobes Target American Sikhs Online Hard Talk Apr 26, 2016
    Is There A Thin Line Between Love And Hate? Interfaith Dialogues Apr 25, 2016
    Hard Talk Taking One Liners Out Of Context From Gurbani To Allow Intellectual Independence? Hard Talk Apr 23, 2016

  3. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    The Report ignore the sorting in the Query.

    Open the Report in DesignView and then use the "Sorting and Grouping"
    feature under the View Menu.

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "PipeMan" <PipeMan@discussions.microsoft.com> wrote in message
    news:375EB0F6-4C12-41BC-AA8A-0AAA0D7066A8@microsoft.com...
    > Please help -
    >
    > I have report called Quotations based on a Form called QuoteForm. Line
    > Items are entered into QuoteForm using a sub-form called QuoteDetails.
    > The
    > Report is layed out so that the line items in the QuoteDetails match in
    > the
    > Report. However, sometimes the line items get scrambled. I do have a
    > LineItemID and the query that QuoteDetails is based, is sorted by the
    > LineItemID. I'm not sure why this happens, but it normally happens after
    > we
    > Compact/Repair the database.
    >
    > Thanks in advance,
    >
    > Greg Pardue
     
  4. PipeMan

    PipeMan
    Expand Collapse
    Guest

    Thanks - it looks like that solved my problem.

    "Van T. Dinh" wrote:

    > The Report ignore the sorting in the Query.
    >
    > Open the Report in DesignView and then use the "Sorting and Grouping"
    > feature under the View Menu.
    >
    > --
    > HTH
    > Van T. Dinh
    > MVP (Access)
    >
    >
    >
    > "PipeMan" <PipeMan@discussions.microsoft.com> wrote in message
    > news:375EB0F6-4C12-41BC-AA8A-0AAA0D7066A8@microsoft.com...
    > > Please help -
    > >
    > > I have report called Quotations based on a Form called QuoteForm. Line
    > > Items are entered into QuoteForm using a sub-form called QuoteDetails.
    > > The
    > > Report is layed out so that the line items in the QuoteDetails match in
    > > the
    > > Report. However, sometimes the line items get scrambled. I do have a
    > > LineItemID and the query that QuoteDetails is based, is sorted by the
    > > LineItemID. I'm not sure why this happens, but it normally happens after
    > > we
    > > Compact/Repair the database.
    > >
    > > Thanks in advance,
    > >
    > > Greg Pardue

    >
    >
    >
     

Share This Page