Right. But we're now facing very strange situation. For some weird reason this SQL doesn't work when we put 0009, which is valid code, into the table. All other codes (valid and invalid) seem to work. I'm looking at this SQL with my eyes open, but I can not find the explanation for this behavior.
>I prefer SQL syntax
... OR Viscodes.ccategory_description IS NULL
>
>>Terrific! So, we just need to add OR IsNull(ccategory_description) part.
>>
>>Haven't thought about it.
>>
>>Thanks again for your sharp brain < g >
>>
>>>You're killing LEFT JOIN with WHERE condition on Viscodes table
>>>
Viscodes.ccategory_description LIKE ( "REVENUE_CODES%" )
>>>
If it's not broken, fix it until it is.
My Blog