Re: [MSAccessProfessionals] HOW DOES ACCESS COUNT?

It counts text as alphabetized text. When numbers are stored as text 

Use a query against this table and *coerce* the text values to actual number like this:

ConvertedValue: IIf(Nz([txtNums],'')<>'' And IsNumeric([txtNums]),CLng([txtNums]),Null)

I hope this helps,

John Stribling 

 

On Mon, Feb 9, 2026 at 1:52 PM Paul Baldy via groups.io <Pbaldy=gmail.com@groups.io> wrote:

What is the data type of the field? It sounds like it's text instead of a numeric type. You're getting an alphabetical sort.

Paul

Sent via mobile device

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Phil, WF3W via groups.io <WF3W=JUNO.COM@groups.io>
Sent: Monday, February 9, 2026 10:43:17 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] HOW DOES ACCESS COUNT?

 

Happy New Year!

 

I trust all have been resigned to the OFFICE price hike...?

 

I have a database of books and their locations. 1 table merely numbers positions 1-343.

 

Everything counts/works as I was taught, in the last century [OUCH!] except... for example, 01 - 10... but after 10 comes 100. After 109 is 11. After 169 is 17. After 279 is 28. The "20s" are most screwed-up. I assumed it was a matter of "places" 028 but nope.

 

Obviously...

 

Thanks for all help & guidance. Crying towels available FREE.

 

Phil

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116765) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_