Line Items Field

M

mingg222

While keying away the other day, I hit a combination of keys and now my line
item field is out of sequence. When I view the report for print, it shows
correct. It's only when I view a Quote and need to change or add information
it is out of order. I have checked the "Forms" & "Reports" and the Sort
Order is correct. Any idea what keys I have hit & how to fix this problem?
Any help is greatly appreciated.
 
A

Allen Browne

In what context is it out of order?

If this is when you view the table, open the table in design view, and clear
its Order By property (in the Properties sheet.)

Queries and forms also have this property.

If you are stuck, you can create a query and specify the Sorting order.
 
M

mingg222

Thank you for your response. Actually this is a report. Some things are in
a table, but the Line Items are not listed in the Tables. I use this for our
company to do Proposals for customers. We have used this setup for years.
Some of it is actually in a Form as well. I have went under the Report &
Form for this and the Sort Order is correct. When I click on a quote to pull
it up to enter information it will have the line items out of order...ex:
52314 instead of 1,2,3,4,5. When I am keying the information in on a new
quote everything is ok. It is when I go out of it and then go back in to add
anything. I remember hitting some keys but I am unsure of what I hit and
can't seem to figure it out. It seems to be sorting by another field on the
quote, but if you go into the Report View the Sort Order is correct. I am
really confused! Thanks.
 
A

Allen Browne

Open the report in design view.

Open the Sorting And Grouping dialog (View menu.)

That's where you specify the sort order for a report.
 
M

mingg222

The Sort Order in Design View is correct. That is why I am so confused. It
makes no sense. I don't know what I have done......:)
 
A

Allen Browne

Hopefully you are clear about the difference between the report's Sorting
And Grouping dialog, and its Order By property.

In the Sorting And Grouping, hopefully it is sorting on each value (not on a
prefix character for example.)

If the Sorting And Grouping dialog contains all the rows you need to
adequately define the sort, but it's still coming out wrong, you could have
a bad index (compact/repair the database), or you could have the wrong data
type (e.g. sorted character by character as text, where you expect numeric
sorting.)
 
Top