E
efandango
I have a query that feeds postcodes to a combo box. problem is that it sorts
them in strict alphanumeric format; like this example:
E1
E10
E11
E12
E2
E3
What i want is:
E1
E2
E3
E10
E11
My query uses another table to make sure only valid (exisitng in the
database) postcodes are pulled from the table, and it seems to be this
connection that makes things difficult to sort in another way.
My SQL:
SELECT tbl_PostCodes.Postcode, tbl_PostCodes.Postcode_ID
FROM tbl_PostCodes INNER JOIN tbl_Points ON tbl_PostCodes.Postcode =
tbl_Points.Run_Point_Postcode
GROUP BY tbl_PostCodes.Postcode, tbl_PostCodes.Postcode_ID;
them in strict alphanumeric format; like this example:
E1
E10
E11
E12
E2
E3
What i want is:
E1
E2
E3
E10
E11
My query uses another table to make sure only valid (exisitng in the
database) postcodes are pulled from the table, and it seems to be this
connection that makes things difficult to sort in another way.
My SQL:
SELECT tbl_PostCodes.Postcode, tbl_PostCodes.Postcode_ID
FROM tbl_PostCodes INNER JOIN tbl_Points ON tbl_PostCodes.Postcode =
tbl_Points.Run_Point_Postcode
GROUP BY tbl_PostCodes.Postcode, tbl_PostCodes.Postcode_ID;