Query Query

[Dowsey1977]

Hi,

I have a table with a list of names in it, with User Name as the unique identifier. I also have a table with a list of users with certain access rights. From this I have created a query that shows just username and access rights. What I want to do is create a form with the first table which just gives user details and then a subform base on the query that shows what access rights that user has. So when you look at a record the query lookups up against the username and then shows what access rights?

Any ideas?

Also, there are 19 columns which can hold information on access right level for each person, any way of only showing the cells tht are populated, but this will cary from person to person.

 

[Ziggy]

This is your 3rd post on the same topic, I responded to the first one. If it is not what you are looking for or don't understand it then Reply to that post. The same applies if you want to rephrase your question,


http://www.mrexcel.com/board2/viewtopic.php?t=94424

Answered:

http://www.mrexcel.com/board2/viewtopic.php?t=94199