Skip to content

Query: SubQry Rpt Bookkeeping Compliance by Company

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

Tables Referenced

  • Submissions
  • MonthLkUp
  • Submission Status

Columns Selected

  • DateSerial([Submission Year],[Month Number],1)
  • Submissions.[Entrepreneur Company ID]
  • Submissions.[Submission Month]
  • Submissions.[Submission Year]
  • [Submission Status].[Submission Status]
  • Submissions.[Issue New Permanent Staff]
  • Submissions.[Issue YTD Does Not Match]

Where Clause

(((DateSerial([Submission Year],[Month Number],1))>=[Forms]![Frm Reports Deliver

SQL

SELECT DateSerial([Submission Year],[Month Number],1), Submissions.[Entrepreneur Company ID], Submissions.[Submission Month], Submissions.[Submission Year], [Submission Status].[Submission Status], Submissions.[Issue New Permanent Staff], Submissions.[Issue YTD Does Not Match] FROM [Submissions], [MonthLkUp], [Submission Status] WHERE (((DateSerial([Submission Year],[Month Number],1))>=[Forms]![Frm Reports Deliver