Recent content by lillyanna

Yes, but it's a left outer join .. this shouldn't be so difficult, I feel like i'm missing something... :banghead::banghead:

Yes, if there are no null fields, it is correct. But if I have null values in table B, then I will get an invalid use of null.

I would like to execute the SQL statement below in vba code written for MS Access, and I want the integer values of the ID fields to be compared in the JOIN ON criteria. However, I get an error when using CInt(). I've also tried Val(), CAST(), and Convert(). Set RecordSet = "SELECT A.id...