Case Sensitive Join in Access

[KHerm]

I've searched this site and the web with the subject as the search criteria, and I'm not finding a way to do case sensitive joins in Access. I came close with StrComp but I can't do outer joins that way.

Is it possible to do case sensitive joins in Access in conjunction with an outer join?

Thanks in advance!

Ken

 

[KHerm]

I seem to have found the answer myself. In my query I am using this construct in the field:

StrComp([table1].[column1],[table2].[column2],0)

In the 'critia' I put 0

and in the 'or' I put Is Null

I think that got it!