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
Post a Comment