Query: Qry Report Blacklisted Applicants
Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No
Tables Referenced
- Positions
- People
- Applications
- Job Codes
- Application Status
Columns Selected
- [Last Name] & \
- People.[Date Blacklisted]
- People.[Reason Blacklisted]
- Job
- Applications.[Application Date]
- [Application Status].[Application Status]
Where Clause
(((People.[Date Blacklisted]) Is Not Null))
Order By
[Last Name] & \
SQL
SELECT [Last Name] & \, People.[Date Blacklisted], People.[Reason Blacklisted], [Job Codes].Job, Applications.[Application Date], [Application Status].[Application Status] FROM [People], [Applications], [Positions], [Application Status], [Job Codes] WHERE (((People.[Date Blacklisted]) Is Not Null))