Line Items Scrambling in Report

#1 (**permalink**) 18-Nov-2005, 14:00 PM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7696-line-items-scrambling-in-report.html
LineItemID. I'm not sure why this happens, but it normally happens after we
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7696
Compact/Repair the database.

Thanks in advance,

Greg Pardue

*

#2 (**permalink**) 18-Nov-2005, 14:00 PM

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" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7696
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7696
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

#3 (**permalink**) 18-Nov-2005, 14:00 PM

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" 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7696
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7696
> > 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
>
>
>