A little change at the end...
Code:WHERE (((StrComp(Left([TBICOUNT].[CountLocation],InStr([TBICOUNT].[CountLocation],":")-1),UCase(Left([TBICOUNT].[CountLocation],InStr([TBICOUNT].[CountLocation],":")-1)),0))<>0));
The not installed error might be a missing reference. It works OK for me with these refs:
Attachment 28356