Line Items Scrambling in Report

[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

 

[Van T. Dinh]

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.

 

[Guest]

Thanks - it looks like that solved my problem.

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.