Sorted Reports

[brettp]

I have a form set up that puts work order numbers into a table. The table is linked to a query that pulls all of the order information. This information is displayed in a report to create a production schedule. I want the report information to be in the same order as the work order numbers are entered. Currently it automatically sorts the information from lowest to highest work order number. How do I make it stop so that it keeps them in the order entered????

 

[mvos]

Hi,

You need to use the sorting and grouping option on the report.

It is available on the design toolbar.

 

[brettp]

I don't want anything to be sorted. One work order might be #056356 and the next may be #000562 and then #060524.

 

[SFukuda]

This may be a silly question, but does your database contain a "Date created" or "Date entered" field? If so, you may be able to select it within your query, not display it, and sort on it.

 

[mvos]

If it hasn't already, create a field in your table based on an autonumber (ideally this should be the Primary Key).

This would be the field to sort on.

 

[brettp]

Thank you for the suggestion. I added an ID column set to autonumber and made it my primary key. I then set it to sort my query based on the ID. Works just like I wanted it to now. THANK YOU

 

[mvos]

You're welcome