Skip to content

Query: Qry Report Financial Detail

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

Tables Referenced

  • Delivery Locations
  • Entrepreneur
  • Entrepreneur Company
  • Entrepreneur Company Programme Years
  • Temp Month Year
  • MonthLkUp
  • CompanyStatus
  • Products
  • Qry Get Last Ignition Date by Company
  • Submissions

Columns Selected

  • [Entrepreneur Company].[Entrepreneur Company ID]
  • [Entrepreneur Company].[Company Name]
  • DateSerial([Submission Year],[Month Number],15)
  • [Delivery Locations].[Delivery Location]
  • Status
  • [Entrepreneur Company].[RC Bookkeeper Assigned]
  • Product
  • [Entrepreneur Company Programme Years].[Programme Year]
  • [Entrepreneur Company Programme Years].[Contract Start Date]
  • Submissions.[Date Created]
  • [Submission Month] & \
  • Turnover
  • IIf(IsNull([Turnover]),0,[Turnover])-IIf(IsNull([Cost of Sales]),0,[Cost of Sale
  • (IIf(IsNull([Turnover]),0,[Turnover])-IIf(IsNull([Cost of Sales]),0,[Cost of Sal
  • Salaries
  • Submissions.[Net Asset Value]
  • Directors
  • Submissions.[Permanent Staff]
  • Submissions.[Contract Staff]

Order By

[Entrepreneur Company].[Company Name], DateSerial([Submission Year],[Month Number],15)

SQL

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], DateSerial([Submission Year],[Month Number],15), [Delivery Locations].[Delivery Location], CompanyStatus.Status, [Entrepreneur Company].[RC Bookkeeper Assigned], Products.Product, [Entrepreneur Company Programme Years].[Programme Year], [Entrepreneur Company Programme Years].[Contract Start Date], Submissions.[Date Created], [Submission Month] & \, Submissions.Turnover, IIf(IsNull([Turnover]),0,[Turnover])-IIf(IsNull([Cost of Sales]),0,[Cost of Sale, (IIf(IsNull([Turnover]),0,[Turnover])-IIf(IsNull([Cost of Sales]),0,[Cost of Sal, Submissions.Salaries, Submissions.[Net Asset Value], Submissions.Directors, Submissions.[Permanent Staff], Submissions.[Contract Staff] FROM [Entrepreneur Company], [Delivery Locations], [Entrepreneur Company Programme Years], [Products], [CompanyStatus], [Qry Get Last Ignition Date by Company], [Submissions], [Temp Month Year], [MonthLkUp]