Hi All,
I've been searching this site and Google for an answer to what seems simple in my head but I cant figure out how to do it in Access. Please can you offer some help?
To explain how my DB works:
Table: I enter data into the table, the data is application name, user ID and entitlement, these are all text columns
Form & Report: I have a listbox where I can select multiple entitlements from the table and a button to open and filter a report based on the entitlement selection.
My issue:
What I would like to do in addition to the above is only show the user IDs that are the same based on the entitlements selected in the listbox rather than all of the users with the entitlements. I think its just an and to the filter I already have on the entitlements but cant seem to do it.
As an example
in the table there is user1 with entitlement 1 and user1 with entitlement 2 and user2 with entitlement 2
If you select entitlement 1 & 2 on the form listbox I would only want User1 returned like the below example
user1 with entitlement 1 user1 with entitlement 2
For some reason, I cant get the user ID part to work, as it shows all users with the selected entitlement.
Thanks in advance for any help.
Cheers Lee
I've been searching this site and Google for an answer to what seems simple in my head but I cant figure out how to do it in Access. Please can you offer some help?
To explain how my DB works:
Table: I enter data into the table, the data is application name, user ID and entitlement, these are all text columns
Form & Report: I have a listbox where I can select multiple entitlements from the table and a button to open and filter a report based on the entitlement selection.
My issue:
What I would like to do in addition to the above is only show the user IDs that are the same based on the entitlements selected in the listbox rather than all of the users with the entitlements. I think its just an and to the filter I already have on the entitlements but cant seem to do it.
As an example
in the table there is user1 with entitlement 1 and user1 with entitlement 2 and user2 with entitlement 2
If you select entitlement 1 & 2 on the form listbox I would only want User1 returned like the below example
user1 with entitlement 1 user1 with entitlement 2
For some reason, I cant get the user ID part to work, as it shows all users with the selected entitlement.
Thanks in advance for any help.
Cheers Lee