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, " &...

It looks like Access has trouble with large strings without newline characters. I've added a bunch of vbNewlines and until now everything seems to work fine.

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...

Well, maybe you can tell me what's going on here: http://www.access-programmers.co.uk/forums/showthread.php?t=167624 It's obvious that Access is doing something wrong. Not always, but occasionaly.

Try: (Nz(tblSuccessfullIncurreds2.InvoiceNumber,0) = Nz(tblPaymentTransactionHeader.PaymentReference,0))

Access does not do exactly as you ask, at least not always. Though I agree with you saying Access is dumb.

What possible query could you make where a left join would return LESS records than an inner join? I'll even make it more complex: 1. When i have 3 rows on the left side and 2 on the right side of the left join it returns 1 row (which make me wanna cry). And as I said it returns 2 when I use...

Very well spoken (babelfish?) :-) Of course I did that first to see what I would expect the outcome to be. As all of the group by fields will not be null (as they are from the left side of the joins) that is not the problem.

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...