Sortere tekst felt som et nummer felt.

Maybe this should be in Access category if we are talking about an mdb file ;-)

You show some adresses but is that the result or as they are entered?

In a text sorting the numerical part is also text so 4 (in the 49) will be before 5

Den rigtige loesning er at aendre database design fra:

adresse TEXT

til

vejnavn TEXT
vejnummer INTEGER

og saa bruge:

SELECT ... ORDER BY postnummer,vejnavn,vejnummer

You could split the address into street name and number in separate fields, and you could also make two calculated fields to sort on

hacket maa vaere:

SELECT ... ORDER BY postnummer,funktionfoermellemrum(vejnavn),funktionkonverterint(funktioneftermellemrum(vejnummer))

hvor funktionfoermellemrum, funktioneftermellemrum og funktionkonverterint skal vaere de rigtige funktioner fra MS Access.

Dem vil jeg skulle slaa op.

SELECT Database.Postnummer, Int(Right([Adresse],Len([Adresse])-InStr(1,[Adresse]," "))) AS Nr
FROM [Database]
ORDER BY Database.Postnummer, Int(Right([Adresse],Len([Adresse])-InStr(1,[Adresse]," ")));

Thanks. I know the right solution is that change street number to its own field and number field, but its not possible whit out large work.
terry: You have a solution, but i can't get it work.
It's in .asp web page and a .mdb database.

set conn = server.createobject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & server.mappath("database.mdb")
conn.open DSN

datavar = "select * from database Order By PostNummer, Adresse ASC"
set nydata = conn.execute(datavar)

I'm no expert at ASP so dont think I can help you with that part :-(

Does the code you give in #7 work but replacing the Select with my code doesn't work?

Yes the code in #7 work, but your in #6 dos not work, but i think that i have to rewrite your code a little.
I understand your code, and you have the right point.
I try, thanks for your post.
If some one know the right syntax for #6 for ASP / MSSQL, i like to have it.

et trick som ERP systemer bruger er at tilføje padding.

med lidt REGEX kan man padde tallet i adressen hvorved den alfabetisk kan sorteres...

det er grimt og langsomt - men en mulighed.

Ulrich, try my SQL directly in your Access dB, just to confirm that it works. If it works save it as a query.

Then in your ASP code you can execute the query as though it were a stored procedure.

Heres an example which I think explains what you need to do.

https://docs.microsoft.com/en-us/sql/ado/guide/data/calling-a-stored-procedure-with-a-command?view=sql-server-2017

I have to fix it on another way, make a field to the house number.
Answer #6 cant do because if i have a street with eg Strandvejen 2 - 7 lejlighed 8
Its get a problem.

Yes it sounds like a redesign of your dB ;-)