Skip to content

Query: Qry Report Current Escalated to PM

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

Tables Referenced

  • Submissions
  • Qry Get Companies Not Non Graduate
  • MonthLkUp
  • Submission Status

Columns Selected

  • Submissions.[Submission ID]
  • [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned]
  • [Qry Get Companies Not Non Graduate].[Company Status ID]
  • Submissions.[Submission Status ID]
  • [Qry Get Companies Not Non Graduate].[Company Name]
  • Submissions.[Submission Year]
  • Submissions.[Submission Month]
  • DateSerial([Submission Year],[Month Number],1)
  • [Submission Month] & \
  • [Submission Status].[Submission Status]
  • [Submission Status].[Sort Order]
  • Submissions.[Date Status Changed]
  • IIf(Not IsNull([Submissions].[Date Status Changed]),DateDiff(\

Where Clause

((([Qry Get Companies Not Non Graduate].[Company Status ID])<>4) AND ((Submissio

SQL

SELECT Submissions.[Submission ID], [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[Company Status ID], Submissions.[Submission Status ID], [Qry Get Companies Not Non Graduate].[Company Name], Submissions.[Submission Year], Submissions.[Submission Month], DateSerial([Submission Year],[Month Number],1), [Submission Month] & \, [Submission Status].[Submission Status], [Submission Status].[Sort Order], Submissions.[Date Status Changed], IIf(Not IsNull([Submissions].[Date Status Changed]),DateDiff(\ FROM [Submissions], [Submission Status], [MonthLkUp], [Qry Get Companies Not Non Graduate] WHERE ((([Qry Get Companies Not Non Graduate].[Company Status ID])<>4) AND ((Submissio