Recent content by Amith

Thanks a lot, it worked! (y) I could have sworn I had tried this one, I usually default to it; I am in the process of shortening a longer query to fix inside the char limit, so I must have swapped them out for the single SELECT *. Thought I was going to be stuck with the old syntax of joining...

Hi, I'm having issues trying to get the following simple SELECT to run as part of a word mail merge using vba . UserName = (Environ$("Username")) sDBPath = "U:\" & UserName & "\db.accdb" SQL = "SELECT * FROM [TestName] T INNER JOIN [TestNameData] D ON T.TestNameId = D.TestNameId"...