Skip to content

Query: Qry Report Current Outstanding Submissions

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.[Date Created]
  • [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]
  • [Submission Month] & \
  • IIf(IsNull([Submission Year]),\
  • [Submission Status].[Submission Status]
  • Submissions.[Date Status Changed]
  • [Submission Status].[Sort Order]

Where Clause

((([Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned]) Is Not Null) A

Order By

IIf(IsNull([Submission Year]),\

SQL

SELECT Submissions.[Date Created], [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], [Submission Month] & \, IIf(IsNull([Submission Year]),\, [Submission Status].[Submission Status], Submissions.[Date Status Changed], [Submission Status].[Sort Order] FROM [Submissions], [Submission Status], [MonthLkUp], [Qry Get Companies Not Non Graduate] WHERE ((([Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned]) Is Not Null) A