Skip to content

Query: Qry Submission List

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

Tables Referenced

  • Submissions
  • MonthLkUp
  • Submission Status

Columns Selected

  • Submissions.[Submission ID]
  • Submissions.[Date Created]
  • Submissions.[Date Books Submitted]
  • Submissions.[Entrepreneur Company ID]
  • [Submission Month] & \
  • IIf(IsNull([Submission Year]),\
  • Bookkeeper
  • [Submission Status].[Submission Status]
  • [Submission Status].[Submission Status ID]
  • Submissions.[Submission Month]
  • Submissions.[Submission Year]
  • Submissions.[Quality Score]
  • MonthLkUp.[Month Number]

SQL

SELECT Submissions.[Submission ID], Submissions.[Date Created], Submissions.[Date Books Submitted], Submissions.[Entrepreneur Company ID], [Submission Month] & \, IIf(IsNull([Submission Year]),\, Submissions.Bookkeeper, [Submission Status].[Submission Status], [Submission Status].[Submission Status ID], Submissions.[Submission Month], Submissions.[Submission Year], Submissions.[Quality Score], MonthLkUp.[Month Number] FROM [Submissions], [Submission Status], [MonthLkUp]