Order Continuous records in Report A to Z (1 Viewer)

T

TxStrob

Registered User.

Local time

Today, 04:15

Joined

Sep 23, 2019

Messages

44

• Oct 20, 2019

• #1

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

AWF VIP

Local time

Today, 03:15

Joined

Mar 9, 2014

Messages

5,470

• Oct 20, 2019

• #2

Use report Sorting & Grouping features.

 

T

TxStrob

Registered User.

Local time

Today, 04:15

Joined

Sep 23, 2019

Messages

44

• Oct 20, 2019

• #3

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

 

isladogs

MVP / VIP

Local time

Today, 12:15

Joined

Jan 14, 2017

Messages

18,216

• Oct 20, 2019

• #4

TxStrob said:

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

Click to expand...

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

AWF VIP

Local time

Today, 03:15

Joined

Mar 9, 2014

Messages

5,470

• Oct 20, 2019

• #5

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.

 

T

TxStrob

Registered User.

Local time

Today, 04:15

Joined

Sep 23, 2019

Messages

44

• Oct 20, 2019

• #6

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

..forever waiting... waiting for jellybean!

Local time

Today, 19:15

Joined

May 7, 2009

Messages

19,234

• Oct 20, 2019

• #7

modify your sort Expression and concatenate another field:

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

 

June7

AWF VIP

Local time

Today, 03:15

Joined

Mar 9, 2014

Messages

5,470

• Oct 20, 2019

• #8

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.

 

T

TxStrob

Registered User.

Local time

Today, 04:15

Joined

Sep 23, 2019

Messages

44

• Oct 20, 2019

• #9

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

 

June7

AWF VIP

Local time

Today, 03:15

Joined

Mar 9, 2014

Messages

5,470

• Oct 20, 2019

• #10

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.

 

T

TxStrob

Registered User.

Local time

Today, 04:15

Joined

Sep 23, 2019

Messages

44

• Oct 21, 2019

• #11

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