Sorting data in forms

[latex88]

This might be the simplest question I've ever asked in this forum. Is it my imagination, or you cannot sort your records based on a field that has number as datatype in MS Access 2010? If I recall Access 2003, you can sort and group your records like you would in reports. Am I just missing the obvious?

 

[Galaxiom]

What happens when you try?

 

[latex88]

I right click the column and choose A - Z. It then sort as if it's text. For example:

1
11
12
2
3
4

 

[Galaxiom]

There are settings to control this behaviour.

Don't know about A2010 but in 2007 click the round button then:
Access Options / Current Database / Filter Lookup Options

 

[missinglinq]

Not to belabor the obvious, but have you double-checked the field's Datatype to make sure it's defined as a Number? As you say, Access is sorting the field as Text.

Linq ;0)>