Skip to content

Query: SubQry Rpt Bookkeeping Compliance All Delivery Locations

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

Tables Referenced

  • Submissions
  • MonthLkUp
  • Submission Status

Columns Selected

  • Submissions.[Entrepreneur Company ID]
  • 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([Date Status Changed]),DateDiff(\

Where Clause

(((Submissions.[Submission Year])=Forms![Frm Reports Delivery Location Company M

SQL

SELECT Submissions.[Entrepreneur Company ID], 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([Date Status Changed]),DateDiff(\ FROM [Submissions], [Submission Status], [MonthLkUp] WHERE (((Submissions.[Submission Year])=Forms![Frm Reports Delivery Location Company M