VBA Code to Sort problem !

[Welshgasman]

So that should indicate that there should be some as something in there is text?
Put it all into a string variable, debug.print it. Copy that to the query SQL window and try and run it. See if that highlights the errant field.

[CJ_London]

I then modified this query, replacing every instance of “ID” with “Regn” (The field I wish to sort on) :-

but you haven’t- for example you have

ON A.Regn>= B.ID