Search results

I've got an Access application which is behaving rather strange. It has trouble handling strings correctly in VBA at random places. For example: strSQL = "SELECT " & strOmschrijving & " AS Omschrijving, CStr(V.Jaar) + ' ' + Format(V." & strPeriode strSQL = strSQL & ",'00') AS Bereik1, " &...

I'm developing an Access application with which reports can be generated dynamically. The SQL I need I create in VBA, because the reports can be grouped and filtered on multiple things. The problem is that when concatenating strings sometimes little parts seem to get lost or overlooked. For...

I have a query with a left join that is acting rather strange. It returns 1 row, though it should return 3 rows (that is what you get if i would leave out the left join and its columns). What is even more remarkable is that it returns 2 rows when changing Left to Inner join. I think i know a...