Sorting numbers from a data extracted from mid query

[gico1972]

I am trying to sort data numerically from a select query which has extracted port of the postal code as i now want to group records by area.

When i however sort data it does not sort it numerically but as follows.

Area: Mid([Post Code],2,2) is used to extract data from post code.

Any help on this would be most welcome.

Thanks



Post Code Area
M1 2FJ 1
M1 5EE 1
M1 4HF 1
M1 3AG 1
M1 4DY 1
M1 6LT 1
M1 4HF 1
M1 1LQ 1
M1 6EU 1
M11 4NR 11
M11 4BD 11
M13 0RX 13
M13 0SH 13
M13 0XL 13
M13 9NS 13
M14 6SQ 14
M14 5AG 14
M14 4RE 14
M14 5TQ 14
M15 4PN 15
M16 0LD 16

 

[Rabbie]

You can only sort numerically if the field is numeric.

In stead of Area: Mid([Post Code],2,2) is used to extract data from post code.
try using

Area: Cint(Mid([Post Code],2,2)) to extract data from post code.