I found a solution. 😀

Thank you so much for your help

SELECT

CASE

WHEN RolesByUser.RoleId Is Null

THEN 'N'

...

Thanks for the reply. The only issue is RolesByUser is not a table. It's a query I created in access.

In other words, I need to merge the two queries...