No emergency here; I was just wondering about something, and thought I'd babble about it here.
I know how to use triple quotes in sql expressions in VBA in order to prevent errors with apostrophes and the like:
randomsql = "SELECT Datum from tblData WHERE Identity = """ & RandomString & """;"
It just always bugs me when I know something works, but not WHY it works. I keep looking at those nested apostrophes and I can't make sense of them. It's like you go out of randomsql, then back in again, then... or maybe not? And why aren't there more &'s in there?
If any of you gurus have time to waste, pray enlighten me. Thanks much.