Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter in report for missing values

Status
Not open for further replies.

hell2010

IS-IT--Management
Sep 29, 2010
7
DE
hi
I need a little bit help.
how is it possible to filter a column where not one of 5 values are in column
i have a report where a user get permissioncodes an i need to find out which user have not min one of the permissioncode 11,16,24,55,36.
the repot is a simple list-report. for example the result of the report:

name user 1, section1, permission 11
name user 1, section1, permission 24
name user 1, section1, permission 33
name user 1, section1, permission 99
name user 2, section2, permission 49
name user 2, section2, permission 61
name user 2, section2, permission 62
name user 2, section2, permission 63
name user 3, section1, permission 04
name user 3, section1, permission 07
name user 3, section1, permission 55
name user 3, section1, permission 99

now the report must show only user 2

thanks a lot
bye
 
You don't say what product you're using, however the logic would be something like
Code:
SELECT DISTINCT [User] FROM [Table] WHERE [User] not in (SELECT DISTINCT [User] FROM [Table] WHERE [Permission] in (11,16,24,55,36))

soi là, soi carré
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top