How to create Crosstab with below conditions

[#1]

Hi All,

I have MS Access table containing 2 columns - Username and Account_Nr. Username RRR and Account_nr 123 being in one record of such table mean, that user RRR does have access to account 123. I do have as well another table with complete list of account numbers.

Based on those I would like to create crosstab in QV (Account_Nr vertically and Username horisontally)showing "x" or any other symbol in case of users & account combinations that do not exist in my Access table (so I would like to see what accounts the user has no access to.

I can not add any other columns in my Access Table

I was thinking it should be easy, and probably is easy but apparently not for me.

[johnw]

if(count(Account),' ','X')

See attached example.

[#3]

Thanks a lot.
I was trying to put the count on the (account,user) but as I see it was not necesary.