No I am not using bits because the user access level per department can rise from 1-3 actually. And also the user can be members of multiple departments. The filter...

Thank you,

Create Table Users (

UserID varchar(50) Primary Key,

L504 int(1),

EXP int(1),

PSA int(1),

SRV int(1),

LEG int(1),

IT int(1),

MGR int(1),

AdminSupport int(1),

Fileroom int(1),

Collateral int(1),

LS bit,

LSA bit

)

Create Table CWAnnouncements (

AnnouncementID numerical Primary Key,

Title varchar(20),

UserID varchar(50),

AllStaff bit,

L504 int(1),

EXP...