Recordset - please help me! how to use multifilters on a recordset

Hi
I am building a financial control system which has different user classes. My problem is that i want buttons to appear or not depending on the user profile on the main page after the user logs in to the system. Now, the user profile is determined by different columns on a MS_access database.
(e.g:User.....Admin....Operator....Consultant
.......userX........1..........1..............1
.......userZ........0..........1..............1
)

Is there a way i can declare a recordset with 2 filters?

(e.g. filter 1: Session Variable: Session.MM_USERNAME(WHERE Username = '#SESSION.MM_USERNAME#')
filter 2: Entered Value: 1 for Admin (WHERE SystemAdmin = '1')
)

In other words, the recordset would look on the user that is logged in and see if the user is an admin. That way i could use the recordset being 'not empty' / 'emty' to display the button (or not) and have other recordsets for the other buttons which would then link to other areas of the system.

The result i am trying to obtain is to continue with the same database structure but to make the buttons dynamic so that they appear if '1' is declared on the coulumn of part of their profile and to disapear if '0' is declared.

Can anyone help me?? or maybe suggest any other idea on how to do this...

Thank you!

Not clear on what you actually need. Why not have the user log in and keep track of their permissions as session variables. Then you can check for any permission you need to and output or not output code to the browser as needed.

The idea of using permitions as session variables seams to work good. Thanks!