Order Continuous records in Report A to Z

[TxStrob]

I have an continuous records in a report, and when I click print view in orders my list of inventory and random order. How do I order the list by A to Z?

 

[June7]

Use report Sorting & Grouping features.

 

[TxStrob]

Thank you June7, and other problem why is blank rows showing as first? I want rows with information show to show first.

 

[isladogs]

Thank you June7, and other problem why is blank rows showing as first? I want rows with information show to show first.

Once again, use sorting and grouping.
However if you have some completely empty records with no data in any fields, you should modify the report record source to exclude them

 

[June7]

Null and empty string sort to top with ascending order. If you want those records at end then need a substitute value, such as Nz([fieldname], "ZZZZZZZZZ") or Nz([fieldname], 99999999). Use that calculated field for sort criteria. It does not have to be displayed on report.

 

[TxStrob]

Awesome you are the best June7, thank you so much. I got everything to the top but now not it's not sorted by A-Z. Since it's sorting by ID number now. Any work around, I tried adding a second expression but nothing.

 

[arnelgp]

modify your sort Expression and concatenate another field:

Nz([sortFieldName], "ZZZZZZ") & Nz([blankFieldName], "ZZZZZZ")

 

[June7]

Post report RecordSource query. What field do you want to sort on? Did you use ORDER BY in query or did you use Report Sorting? Report Sorting & Grouping overrides query ORDER BY.

 

[TxStrob]

June I used the report sort and group. Let me see if I can order by query now.

 

[June7]

Don't rely on query sort in a report. Use report sorting.

If you want to provide db for analysis, follow instructions at bottom of my post.

 

[TxStrob]

I am living with the way it sorts thank you everyone for helping me resolve this problem