M
Mr. T.
Hi,
i have a table with adresses in it. The house number is a text field. The
reasen for that is that house numbers can have a letter attached to it. For
example, you can have a house number 50 a number 50a and 50b.
Now when i do my query and want the numbers ordered, because of the
housenumberfield being a text, it doesn't order correctly. If f.e. i have
the following house numbers in my table : 1, 2, 5, 10, 20, 40
it will return the list as follows: 1, 10, 2, 20, 40, 5
when what i really want is 1, 2, 5, 10, 20, 40
anyone has a simple solution to that problem? This is the sql i'm using:
sql = "SELECT [Nr], [BVNr] FROM [adressen] WHERE [Street] = " & """" &
Street & """"
Thx in advance & kind regards!
Thomas L.
i have a table with adresses in it. The house number is a text field. The
reasen for that is that house numbers can have a letter attached to it. For
example, you can have a house number 50 a number 50a and 50b.
Now when i do my query and want the numbers ordered, because of the
housenumberfield being a text, it doesn't order correctly. If f.e. i have
the following house numbers in my table : 1, 2, 5, 10, 20, 40
it will return the list as follows: 1, 10, 2, 20, 40, 5
when what i really want is 1, 2, 5, 10, 20, 40
anyone has a simple solution to that problem? This is the sql i'm using:
sql = "SELECT [Nr], [BVNr] FROM [adressen] WHERE [Street] = " & """" &
Street & """"
Thx in advance & kind regards!
Thomas L.