sql - Access 2010 filter report based on form selection and duplicates in table -


i've been searching site , google answer seems simple in head cant figure out how in access.

to explain how db works:

table: enter data table, data application name, user id , entitlement, these text columns

form & report: have listbox can select multiple entitlements table , button open , filter report based on entitlement selection.

my issue in addition above show user ids same based on entitlements selected in list box rather of users entitlements.

as example

in table there user1 entitlement 1 user1 entitlement 2 user2 entitlement 2

if select entitlement 1 & 2 on form listbox want user1 returned

user1 entitlement 1 user1 entitlement 2

for reason, cant user id part work, shows users selected entitlement.

thanks in advance help.

cheers lee


Comments

Popular posts from this blog

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

html - How to custom Bootstrap grid height? -

angular - Copying node modules to wwwroot AspNetCore -