Re: [MSAccessProfessionals] HOW DOES ACCESS COUNT?

Look at the column in datasheet view. If it is left-aligned, the values are being treated as text. If right-aligned, then numeric. You could try wrap your expression in a function that would convert the value to numeric like: 

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

Duane

---

From: J. Stribling via groups.io <Jms4th=gmail.com@groups.io>
Sent: Monday, February 9, 2026 9:46 PM

 

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: Phil, WF3W via groups.io <WF3W=JUNO.COM@groups.io>
Sent: Monday, February 9, 2026 10:43:17 AM

 

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

_