Skip to content

Query: Qry User Module List

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • DatabaseUsers
  • DatabaseUsers Module Permissions

Columns Selected

  • DatabaseUsers.[User ID]
  • Username
  • Department
  • [DatabaseUsers Module Permissions].[Module Permission]
  • LEVEL

Where Clause

((([DatabaseUsers Module Permissions].LEVEL)<>\"Disabled\"))

SQL

SELECT DatabaseUsers.[User ID], DatabaseUsers.Username, DatabaseUsers.Department, [DatabaseUsers Module Permissions].[Module Permission], [DatabaseUsers Module Permissions].LEVEL FROM [DatabaseUsers], [DatabaseUsers Module Permissions] WHERE ((([DatabaseUsers Module Permissions].LEVEL)<>\"Disabled\"))