Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
if(count(Account),' ','X')
See attached example.
Thanks a lot.
I was trying to put the count on the (account,user) but as I see it was not necesary.