Re: [MSAccessProfessionals] HOW DOES ACCESS COUNT?

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