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.
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.
Last edited by Welshgasman; 06-17-2023 at 12:22 PM.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
but you haven’t- for example you haveI then modified this query, replacing every instance of “ID” with “Regn” (The field I wish to sort on) :-
ON A.Regn>= B.ID