Skip to content

Query: Qry Get Financial Information by Month Number

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

Tables Referenced

  • Submissions
  • MonthLkUp

Columns Selected

  • Submissions.[Entrepreneur Company ID]
  • MonthLkUp.[Month Number]
  • Submissions.[Submission Year]
  • Turnover
  • Submissions.[Cost of Sales]
  • Submissions.[Direct Labour Costs]
  • Submissions.[Expenses Salary]
  • Submissions.[Other Income]
  • Salaries
  • Submissions.[Net Asset Value]

SQL

SELECT Submissions.[Entrepreneur Company ID], MonthLkUp.[Month Number], Submissions.[Submission Year], Submissions.Turnover, Submissions.[Cost of Sales], Submissions.[Direct Labour Costs], Submissions.[Expenses Salary], Submissions.[Other Income], Submissions.Salaries, Submissions.[Net Asset Value] FROM [Submissions], [MonthLkUp]