amber - Implementation Details

VBA Modules

Form_Backdoor Frm Add and Edit Financial Data (Form)

File: ms_access_files\amber\Forms\Backdoor Frm Add and Edit Financial Data.txt Lines: 196

Procedures

Public Sub SaveTheChanges()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Contract_Staff_AfterUpdate()

Private Sub Cost_of_Sales_AfterUpdate()

Private Sub Date_Proof_of_Employment_Collected_AfterUpdate()

Private Sub Direct_Labour_Costs_AfterUpdate()

Private Sub Directors_AfterUpdate()

Private Sub Expenses_Salary_AfterUpdate()

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Private Sub Net_Asset_Value_AfterUpdate()

Private Sub Other_Income_AfterUpdate()

Private Sub Permanent_Staff_AfterUpdate()

Private Sub Salaries_AfterUpdate()

Private Sub SaveIt_Click()

Private Sub Turnover_AfterUpdate()

Form_Backdoor Frm Add and Edit Pre Ignition Financials (Form)

File: ms_access_files\amber\Forms\Backdoor Frm Add and Edit Pre Ignition Financials.txt Lines: 124

Procedures

Private Sub CloseForm_Click()

Private Sub CloseFormAndSave_Click()

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Form_Backdoor Frm Company List (Form)

File: ms_access_files\amber\Forms\Backdoor Frm Company List.txt Lines: 120

Procedures

Public Sub UpdateList()

Private Sub AddPreIgnition_Click()

Private Sub AddSubmission_Click()

Private Sub ClearFilters_Click()

Private Sub CloseForm_Click()

Private Sub CompanyList_AfterUpdate()

Private Sub Filter1_AfterUpdate()

Private Sub Form_Open(Cancel As Integer)

Private Sub PreIgnitionList_DblClick(Cancel As Integer)

Private Sub PreIgnitionList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub StrCriteria1_AfterUpdate()

Private Sub SubmissionList_DblClick(Cancel As Integer)

Private Sub SubmissionList_KeyDown(KeyCode As Integer, Shift As Integer)

Form_Add and Edit Amber Distribution Models (Form)

File: ms_access_files\amber\Forms\Frm Add and Edit Amber Distribution Models.txt Lines: 56

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Amber Products (Form)

File: ms_access_files\amber\Forms\Frm Add and Edit Amber Products.txt Lines: 56

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Bookkeeper Assigned Delivery Locations (Form)

File: ms_access_files\amber\Forms\Frm Add and Edit Bookkeeper Assigned Delivery Locations.txt Lines: 56

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Pre Ignition Financials (Form)

File: ms_access_files\amber\Forms\Frm Add and Edit Pre Ignition Financials.txt Lines: 179

Procedures

Private Sub CloseForm_Click()

Private Sub CloseFormAndSave_Click() - ⚠️ High branching (13 If statements); Large procedure (106 lines)

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Form_Add and Edit Submission Status (Form)

File: ms_access_files\amber\Forms\Frm Add and Edit Submission Status.txt Lines: 35

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add Submission (Form)

File: ms_access_files\amber\Forms\Frm Add Submission.txt Lines: 79

Procedures

Private Sub CloseForm_Click()

Private Sub CloseFormAndSave_Click()

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Form_Alerts List (Form)

File: ms_access_files\amber\Forms\Frm Alerts List.txt Lines: 20

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Form_Archive Submissions Dialog (Form)

File: ms_access_files\amber\Forms\Frm Archive Submissions Dialog.txt Lines: 215

Procedures

Private Sub Form_Open(Cancel As Integer)

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements; Large procedure (190 lines)

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Assign Bookkeeper (Form)

File: ms_access_files\amber\Forms\Frm Assign Bookkeeper.txt Lines: 74

Procedures

Private Sub Bookkeeper_Assigned_AfterUpdate()

Private Sub Bookkeeper_Software_AfterUpdate()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Private Sub Own_Bookkeeper_AfterUpdate()

Form_Change Password (Form)

File: ms_access_files\amber\Forms\Frm Change Password.txt Lines: 138

Procedures

Private Sub CancelButton_Click()

Private Sub CurrentPassword_AfterUpdate()

Private Sub Form_Open(Cancel As Integer)

Private Sub NewPassword_AfterUpdate()

Private Sub OKButton_Click()

Form_Company List (Form)

File: ms_access_files\amber\Forms\Frm Company List.txt Lines: 318

Procedures

Public Sub UpdateList() - ⚠️ High branching (19 If statements)

Private Sub AddPreIgnition_Click()

Private Sub AddSubmission_Click()

Private Sub ArchiveSubmissions_Click()

Private Sub Assigned_AfterUpdate()

Private Sub ChangePassword_Click()

Private Sub ClearFilters_Click()

Private Sub CloseForm_Click()

Private Sub CompanyList_AfterUpdate()

Private Sub CompanyList_DblClick(Cancel As Integer)

Private Sub CriteriaCombo1_AfterUpdate()

Private Sub Filter1_AfterUpdate()

Private Sub Form_Open(Cancel As Integer) - ⚠️ High branching (6 If statements)

Private Sub ImportFunction_Click()

Private Sub MaintenanceFunction_Click()

Private Sub PreIgnitionList_DblClick(Cancel As Integer)

Private Sub PreIgnitionList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub ReportMenu_Click()

Private Sub StrCriteria1_AfterUpdate()

Private Sub SubmissionList_DblClick(Cancel As Integer)

Private Sub SubmissionList_KeyDown(KeyCode As Integer, Shift As Integer) - ⚠️ High branching (6 If statements)

Form_Edit Financial Data (Form)

File: ms_access_files\amber\Forms\Frm Edit Financial Data.txt Lines: 556

Procedures

Public Sub CheckTheYTDFigures() - ⚠️ High branching (19 If statements); Large procedure (136 lines)

Public Sub SaveTheChanges() - ⚠️ High branching (20 If statements); Large procedure (118 lines)

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Contract_Staff_AfterUpdate()

Private Sub Cost_of_Sales_AfterUpdate()

Private Sub Date_Proof_of_Employment_Collected_AfterUpdate()

Private Sub Direct_Labour_Costs_AfterUpdate()

Private Sub Directors_AfterUpdate()

Private Sub EnterYTDFinancials_Click()

Private Sub Expenses_Salary_AfterUpdate()

Private Sub Form_Open(Cancel As Integer)

Private Sub Net_Asset_Value_AfterUpdate()

Private Sub Other_Income_AfterUpdate()

Private Sub Permanent_Staff_AfterUpdate()

Private Sub Salaries_AfterUpdate()

Private Sub SaveIt_Click()

Private Sub Turnover_AfterUpdate()

Private Sub YTD_Cost_of_Sales_AfterUpdate()

Private Sub YTD_Direct_Labour_Costs_AfterUpdate()

Private Sub YTD_Expenses_Salary_AfterUpdate()

Private Sub YTD_Net_Asset_Value_AfterUpdate()

Private Sub YTD_Other_Income_AfterUpdate()

Private Sub YTD_Salaries_AfterUpdate()

Private Sub YTD_Turnover_AfterUpdate()

Form_Edit Submission (Form)

File: ms_access_files\amber\Forms\Frm Edit Submission.txt Lines: 340

Procedures

Public Sub SaveTheChanges() - ⚠️ High branching (8 If statements)

Private Sub Bookkeeper_AfterUpdate()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Contract_Staff_AfterUpdate()

Private Sub Cost_of_Sales_AfterUpdate()

Private Sub Directors_AfterUpdate()

Private Sub Expenses_No_Salary_AfterUpdate()

Private Sub Expenses_Salary_AfterUpdate()

Private Sub EditFinancialData_Click()

Private Sub Form_Open(Cancel As Integer) - ⚠️ High branching (7 If statements)

Private Sub Net_Asset_Value_AfterUpdate()

Private Sub Other_Income_AfterUpdate()

Private Sub Permanent_Staff_AfterUpdate()

Private Sub QualityScore_AfterUpdate()

Private Sub Reviewed_by_Guide_AfterUpdate()

Private Sub Salaries_AfterUpdate()

Private Sub SaveIt_Click()

Private Sub Submission_Month_AfterUpdate()

Private Sub Submission_Status_ID_AfterUpdate()

Private Sub Submission_Status_Notes_AfterUpdate()

Private Sub Submission_Year_AfterUpdate()

Private Sub Turnover_AfterUpdate()

Form_ESD Report Principal Project Dialog (Form)

File: ms_access_files\amber\Forms\Frm ESD Report Principal Project Dialog.txt Lines: 44

Procedures

Private Sub Form_Close()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Maintenance Menu (Form)

File: ms_access_files\amber\Forms\Frm Maintenance Menu.txt Lines: 40

Procedures

Private Sub AmberDistributionModels_Click()

Private Sub AmberProducts_Click()

Private Sub BookkeeperAssignedDeliveryLocation_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub SubmissionStatus_Click()

Private Sub Users_Click()

Form_Opening Dialog (Form)

File: ms_access_files\amber\Forms\Frm Opening Dialog.txt Lines: 125

Procedures

Private Sub CancelButton_Click()

Private Sub Form_Open(Cancel As Integer)

Private Sub Password_AfterUpdate() - ⚠️ High branching (7 If statements)

Private Sub Username_AfterUpdate()

Private Sub Username_KeyDown(KeyCode As Integer, Shift As Integer)

Form_Report Menu (Form)

File: ms_access_files\amber\Forms\Frm Report Menu.txt Lines: 120

Procedures

Private Sub BookkeeperTrackerReport_Click()

Private Sub BookkeepingComplianceReport_Click()

Private Sub BooksNotSubmittedReport_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub CompaniesAssignedReport_Click()

Private Sub DetailedSubmissionReport_Click()

Private Sub EscaledtoPMReport_Click()

Private Sub ESDUpdateReport_Click()

Private Sub FinancialDetailReport_Click()

Private Sub FinancialSummaryReport_Click()

Private Sub IncompleteSubmissionReport_Click()

Private Sub PrincipalSpendCompanyOneMonthReport_Click()

Private Sub PrincipalSpendReport_Click()

Private Sub PrincipalSpendTrackingReport_Click()

Private Sub PrincipalSpendYTDReport_Click()

Private Sub PurchasedEDvsSDReport_Click()

Private Sub QueriedWithEPReport_Click()

Private Sub SDMOpalShiftReport_Click()

Form_Reports Bookkeeper Dialog (Form)

File: ms_access_files\amber\Forms\Frm Reports Bookkeeper Dialog.txt Lines: 42

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Books Not Submitted Dialog (Form)

File: ms_access_files\amber\Forms\Frm Reports Books Not Submitted Dialog.txt Lines: 60

Procedures

Private Sub BookkeeperOption_AfterUpdate()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Company Dialog (Form)

File: ms_access_files\amber\Forms\Frm Reports Company Dialog.txt Lines: 42

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Date Dialog (Form)

File: ms_access_files\amber\Forms\Frm Reports Date Dialog.txt Lines: 85

Procedures

Public Sub PopulateMonthYearTable()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Delivery Location Company Month Year Dialog (Form)

File: ms_access_files\amber\Forms\Frm Reports Delivery Location Company Month Year Dialog.txt Lines: 111

Procedures

Public Sub PopulateTempComplianceByCompany()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements; High branching (14 If statements)

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Private Sub ReportType_AfterUpdate()

Private Sub Submission_Month_AfterUpdate()

Private Sub Submission_Year_AfterUpdate()

Form_Reports Delivery Location Dialog (Form)

File: ms_access_files\amber\Forms\Frm Reports Delivery Location Dialog.txt Lines: 42

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Month Year Dialog (Form)

File: ms_access_files\amber\Forms\Frm Reports Month Year Dialog.txt Lines: 70

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements; High branching (7 If statements)

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Private Sub Submission_Month_AfterUpdate()

Form_Reports Principal Project Dialog (Form)

File: ms_access_files\amber\Forms\Frm Reports Principal Project Dialog.txt Lines: 41

Procedures

Private Sub Form_Close()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Year Dialog (Form)

File: ms_access_files\amber\Forms\Frm Reports Year Dialog.txt Lines: 48

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_SubFrm Submission Principal Spend (Form)

File: ms_access_files\amber\Forms\SubFrm Submission Principal Spend.txt Lines: 39

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub Entrepreneur_Company_Principal_Project_ID_AfterUpdate()

Private Sub Form_BeforeUpdate(Cancel As Integer)

Private Sub Principal_Spend_AfterUpdate()

basRelink (Standard)

File: ms_access_files\amber\Modules\basRelink.bas Lines: 604

Procedures

Public Function RelinkODBC() As Boolean - ⚠️ Contains GoTo statements; High branching (7 If statements); Large procedure (153 lines)

Public Function Update_zstblODBC() As Boolean - ⚠️ Contains GoTo statements

Public Function RelinkTablesLocal() As Boolean - ⚠️ Contains GoTo statements

Public Function CompactTablesMain() As Boolean - ⚠️ Contains GoTo statements

Public Function CompactTablesLocal() As Boolean - ⚠️ Contains GoTo statements

Public Function TableExists(ByVal pstrTableName As String) As Boolean - ⚠️ Uses On Error Resume Next

Public Sub PopulateTableList() - ⚠️ Contains GoTo statements

Mod Export to Excel (Standard)

File: ms_access_files\amber\Modules\Mod Export to Excel.bas Lines: 2632

Procedures

Public Sub ExportBookingComplianceByDeliveryLocationToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; Large procedure (104 lines)

Public Sub ExportFinanceSummaryToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; Large procedure (211 lines)

Public Sub ExportFinanceDetailToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; High branching (7 If statements); Large procedure (221 lines)

Public Sub ExportPrincipalSpendByDeliveryLocationToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements

Public Sub ExportPrincipalSpendByCompanyToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements

Public Sub ExportBookingComplianceByCompanyToExcel(FromAuto As Boolean, Optional TheFileName As String, Optional ByDeliveryLocation As Boolean) - ⚠️ Contains GoTo statements; High branching (13 If statements); Large procedure (180 lines)

Public Sub ExportPrincipalSpendByPrincipalCompanyOneMonthToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; High branching (7 If statements); Large procedure (145 lines)

Public Sub ExportPrincipalSpendTrackingToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; High branching (9 If statements); Large procedure (294 lines)

Public Sub ExportPrincipalSpendByPrincipalYTDToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; Large procedure (114 lines)

Public Sub ExportSDMOpalShiftReportToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; Large procedure (124 lines)

Public Sub ExportBookkeeperTrackerToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; Large procedure (150 lines)

Public Sub ExportPrincipalProjectsPurchasedEDvsSDToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; High branching (10 If statements); Large procedure (278 lines)

Public Sub ExportESDReporttoExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; High branching (20 If statements); Large procedure (604 lines)

Public Sub TestIt()

Mod Import Excel (Standard)

File: ms_access_files\amber\Modules\Mod Import Excel.bas Lines: 183

Procedures

Public Sub ImportFinancials(FromAuto As Boolean) - ⚠️ Contains GoTo statements; High branching (13 If statements); Large procedure (181 lines)

Mod Utilities (Standard)

File: ms_access_files\amber\Modules\Mod Utilities.bas Lines: 158

Procedures

Public Sub WriteFinancialHistoryRecord(CompID As Long, FldName As String, NewVal As Double, RecType As String)

Public Function GetXofY(f As Form) - ⚠️ Uses On Error Resume Next

Public Function IsLoaded(ByVal strFormName As String) As Boolean

Public Function StringsSameCase(x As String, y As String) As Boolean

Public Function CheckForUpper(CheckString As String)

Public Function CheckForSpecial(CheckString As String)

Public Function CheckForNumber(CheckString As String)

Public Sub DeleteImportErrorTables()

Public Sub ObjectCounts()

SQL Queries

Backdoor Qry Company List

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[RC Bookkeeper Assigned], IIf([Own Bookkeeper]=True,\, [Qry Get Last Complete Submission by Company].[Last Completed] FROM [Entrepreneur Company], [Qry Get Last Complete Submission by Company]

JB Initialize Company Added New Staff

Type: Update

SELECT Null FROM [Submissions]

Qry Assigned Companies with No Submissions

Type: Select

SELECT [Entrepreneur Company].[RC Bookkeeper Assigned], Entrepreneurs.[Process Status ID], [Entrepreneur Company].[Company Name], Submissions.[Entrepreneur Company ID] FROM [Entrepreneur Company], [Entrepreneurs], [Submissions] WHERE ((([Entrepreneur Company].[RC Bookkeeper Assigned]) Is Not Null) AND ((Entrepren

Qry Company List

Type: Select

SELECT vwAmberCompanyList.[Distribution Model ID], vwAmberCompanyList.[Company Status ID], vwAmberCompanyList.[Entrepreneur Company ID], vwAmberCompanyList.[Company Name], vwAmberCompanyList.[Programme Year], vwAmberCompanyList.Product, vwAmberCompanyList.[Delivery Location], vwAmberCompanyList.[RC Bookkeeper Assigned], IIf([Own Bookkeeper]=True,\, [Last Complete Submission Month] & \, vwAmberCompanyList.[Last Ignition Date], IIf(IsNull([Last Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd(, IIf(IsNull([Last Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd( FROM [vwAmberCompanyList], [MonthLkUp]

Qry Company Submission List

Type: Select

SELECT vwAmberCompanySubmissionList.[Company Programme Year Status ID], vwAmberCompanySubmissionList.[Company Status ID], vwAmberCompanySubmissionList.[Entrepreneur Company ID], vwAmberCompanySubmissionList.[Company Name], vwAmberCompanySubmissionList.[Programme Year], vwAmberCompanySubmissionList.Product, vwAmberCompanySubmissionList.[Delivery Location], vwAmberCompanySubmissionList.[RC Bookkeeper Assigned], IIf([Own Bookkeeper]=True,\, vwAmberCompanySubmissionList.[Last Ignition Date], IIf(Not IsNull([Last Status Change]),DateDiff(\, IIf(IsNull([Last Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd(, IIf(IsNull([Last Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd( FROM [MonthLkUp], [vwAmberCompanySubmissionList]

Qry Count Companies Assigned by Bookkeeper

Type: Select

SELECT [Qry Report Companies Assigned].[Delivery Location], [Qry Report Companies Assigned].[RC Bookkeeper Assigned], [Qry Report Companies Assigned].[Their Own Bookkeeper], Count([Qry Report Companies Assigned].[Entrepreneur Company ID]) FROM [Qry Report Companies Assigned]

Qry Count ED or SD Companies Bought From by Principal Project

Type: Select

SELECT [SubQry Count ED or SD Companies Bought From by Principal Project].[Principal Pr, Count([SubQry Count ED or SD Companies Bought From by Principal Project].[Entrep FROM [SubQry Count ED or SD Companies Bought From by Principal Project]

Qry Count Number ED Allocated by Principal Project Pillar

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], [Principal Project Pillars].[BBBEE Pillar], Count([Entrepreneur Company Principal Projects].[Entrepreneur Company Principal  FROM [Principal Project Pillars], [Entrepreneur Company Principal Projects]

Qry Count Number SD Allocated by Principal Project Pillar

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], [Principal Project Pillars].[BBBEE Pillar], Count([Entrepreneur Company Principal Projects].[Entrepreneur Company Principal  FROM [Principal Project Pillars], [Entrepreneur Company Principal Projects]

Qry Count Pre-Ignition Financial Entries by Company

Type: Select

SELECT [Entrepreneur Company Pre Ignition Financials].[Entrepreneur Company ID], Count([Entrepreneur Company Pre Ignition Financials].[Pre Ignition ID]) FROM [Entrepreneur Company Pre Ignition Financials]

Qry Count Submission Financial Complete Entries by Company

Type: Select

SELECT Submissions.[Entrepreneur Company ID], Submissions.[Submission Status ID], Count(Submissions.[Submission ID]) FROM [Submissions]

Qry Get Companies Assigned Both Bookkeepers

Type: Select

SELECT [Qry Get Companies Not Non Graduate].[Entrepreneur Company ID], [Qry Get Companies Not Non Graduate].[Company Status ID], [Delivery Locations].[Delivery Location], [Qry Get Companies Not Non Graduate].[Company Delivery Location ID], [Qry Get Companies Not Non Graduate].[Company Name], [Qry Get Companies Not Non Graduate].[Own Bookkeeper], [Qry Get Companies Not Non Graduate].[Date RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], IIf(IsNull([Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd(\ FROM [Qry Get Companies Not Non Graduate], [Qry Get Last Submission ID by Company], [Submissions], [MonthLkUp], [Delivery Locations]

Qry Get Companies Assigned Raizcorp Bookkeeper

Type: Select

SELECT [Qry Get Companies Not Non Graduate].[Entrepreneur Company ID], [Qry Get Companies Not Non Graduate].[Company Status ID], [Delivery Locations].[Delivery Location], [Qry Get Companies Not Non Graduate].[Company Delivery Location ID], [Qry Get Companies Not Non Graduate].[Company Name], [Qry Get Companies Not Non Graduate].[Own Bookkeeper], [Qry Get Companies Not Non Graduate].[Date RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], IIf(IsNull([Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd(\ FROM [Qry Get Companies Not Non Graduate], [Qry Get Last Submission ID by Company], [Submissions], [MonthLkUp], [Delivery Locations]

Qry Get Companies for Principal Spend Tracking Report

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Entrepreneur Company Principal Projects].[Entrepreneur Company Principal Projec, [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneurs] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=1)

Qry Get Companies Not Non Graduate

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Delivery Location ID], [Entrepreneur Company].[Company Status ID], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Own Bookkeeper], [Entrepreneur Company].[Date RC Bookkeeper Assigned], [Entrepreneur Company].[RC Bookkeeper Assigned], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], [Qry Get Last Ignition Date by Company].[Last Ignition Date], [Entrepreneur Company Programme Years].[Product ID] FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Qry Get Last Ignition Date by Company], [vwAmberCompanyList] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])<>5

Qry Get Delivery Locations for Bookkeeping Compliance Report

Type: Select

SELECT [Delivery Locations].[Delivery Location ID], [Delivery Locations].[Delivery Location], DatabaseUsers.[Email Address] FROM [Delivery Locations], [DatabaseUsers], [Entrepreneur Company], [Submissions]

Qry Get Financial Information by Month Number

Type: Select

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]

Qry Get Highest Permanent Staff Number

Type: Select

SELECT Submissions.[Entrepreneur Company ID], Max(Submissions.[Permanent Staff]) FROM [Submissions]

Qry Get Last Complete Submission by Company

Type: Select

SELECT Submissions.[Entrepreneur Company ID], [Submission Month] & \, [SubQry Get Last Complete Submission by Company].[Submission ID] FROM [SubQry Get Last Complete Submission by Company], [Qry Get Last Complete Submission ID by Company], [Submissions]

Qry Get Last Complete Submission ID by Company

Type: Select

SELECT Submissions.[Entrepreneur Company ID], Submissions.[Submission Status ID], Max(DateSerial([Submission Year],[Month Number],1)) FROM [Submissions], [MonthLkUp]

Qry Get Last Ignition Date by Company

Type: Select

SELECT [Entrepreneur Company Programme Years].[Entrepreneur Company ID], Max([Entrepreneur Company Programme Years].[Ignition Date]) FROM [Entrepreneur Company Programme Years] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])<>6

Qry Get Last Month Principal Spend YTD

Type: Select

SELECT Submissions.[Submission Year], Max(MonthLkUp.[Month Number]) FROM [Entrepreneur Company], [Submissions], [Submissions Principal Spend], [MonthLkUp] WHERE ((([Submissions Principal Spend].[Principal Spend]) Is Not Null))

Qry Get Last Pre-Ignition Job Entry by Company

Type: Select

SELECT [Entrepreneur Company Pre Ignition Financials].[Entrepreneur Company ID], [Entrepreneur Company Pre Ignition Financials].Directors, [Entrepreneur Company Pre Ignition Financials].[Permanent Staff], [Entrepreneur Company Pre Ignition Financials].[Contract Staff] FROM [Qry Get Last Pre-Ignition Month Name Year by Company], [Entrepreneur Company Pre Ignition Financials]

Qry Get Last Pre-Ignition Month Name Year by Company

Type: Select

SELECT [Qry Get Last Pre-Ignition Month Year by Company].[Entrepreneur Company ID], MonthLkUp.[Month Name], [Qry Get Last Pre-Ignition Month Year by Company].[Last Year] FROM [MonthLkUp], [Qry Get Last Pre-Ignition Month Year by Company]

Qry Get Last Pre-Ignition Month Year by Company

Type: Select

SELECT [Entrepreneur Company Pre Ignition Financials].[Entrepreneur Company ID], Max(MonthLkUp.[Month Number]), Max([Entrepreneur Company Pre Ignition Financials].[Submission Year]) FROM [Entrepreneur Company Pre Ignition Financials], [MonthLkUp]

Qry Get Last Programme Year ID by Company

Type: Select

SELECT [Entrepreneur Company Programme Years].[Entrepreneur Company ID], Max([Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years FROM [Entrepreneur Company Programme Years] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])<>6

Qry Get Last Programme Year Pillar by Principal Project

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], [Principal Project Pillars].[Principal Project ID], [Qry Get Last Programme Year ID by Company].[Entrepreneur Company ID], [Principal Project Pillars].[BBBEE Pillar], [Entrepreneur Company Programme Years].[Product ID], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], [Entrepreneur Company Programme Years].[Date Status Changed], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Qry Get Last Programme Year ID by Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Qry Sum Total Allocated by Entrepreneur Programme Year]

Qry Get Last Status Change by Company

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], Max(Submissions.[Date Status Changed]) FROM [Entrepreneur Company], [Submissions]

Qry Get Last Submission ID by Company

Type: Select

SELECT Submissions.[Entrepreneur Company ID], Max(Submissions.[Submission ID]) FROM [Submissions]

Qry Get Last Submission Job Entry by Company

Type: Select

-- Unable to parse query definition

Qry Get Months Included Financial Detail

Type: Select

SELECT [Qry Report Financial Detail].[Submission Date Criteria] FROM [Qry Report Financial Detail]

Qry Get Permanent Staff Numbers by Submission Date

Type: Select

SELECT Submissions.[Entrepreneur Company ID], Submissions.[Submission Month], Submissions.[Submission Year], DateSerial([Submission Year],[Month Number],1), Submissions.[Permanent Staff] FROM [Submissions], [MonthLkUp]

Qry Get Principal Projects for Principal Spend Tracking Report

Type: Select

SELECT [Principal Projects].[Principal Project ID], [Principal] & \, [Client Tiers].[Client Tier], Principals.FYE FROM [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals], [Client Tiers], [Entrepreneur Company], [Entrepreneurs] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=1)

Qry Get Principal Projects for Purchased ED vs SD Report

Type: Select

SELECT [Principal Projects].[Principal Project ID] FROM [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Client Tiers], [Entrepreneur Company], [Entrepreneurs] WHERE ((([Client Tiers].[Client Tier]) Is Not Null) AND (([Entrepreneur Company Progra

Qry Get Principal Spend by Submission Date

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], Submissions.[Entrepreneur Company ID], Submissions.[Submission Month], Submissions.[Submission Year], DateSerial([Submission Year],[Month Number],1), [Submissions Principal Spend].[Principal Spend] FROM [Submissions], [MonthLkUp], [Submissions Principal Spend], [Entrepreneur Company Principal Projects], [Principal Project Pillars]

Qry Populate Temp Compliance by Company

Type: Delete

SELECT [Delivery Locations].[Delivery Location ID], [Delivery Locations].[Delivery Location], [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[Entrepreneur Company ID], [Qry Get Companies Not Non Graduate].[Company Name], IIf([Own Bookkeeper]=True,\, [SubQry Rpt Bookkeeping Compliance by Company].SubmissionDate, [SubQry Rpt Bookkeeping Compliance by Company].[Submission Status], [SubQry Rpt Bookkeeping Compliance by Company].[Issue New Permanent Staff], [SubQry Rpt Bookkeeping Compliance by Company].[Issue YTD Does Not Match] FROM [Qry Get Companies Not Non Graduate], [Delivery Locations], [Qry Get Last Submission ID by Company], [Submissions], [MonthLkUp], [SubQry Rpt Bookkeeping Compliance by Company] WHERE ((([Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned]) Is Not Null) A

Qry Pre Ignition List

Type: Select

SELECT [Entrepreneur Company Pre Ignition Financials].[Pre Ignition ID], [Entrepreneur Company Pre Ignition Financials].[Date Created], [Entrepreneur Company Pre Ignition Financials].[Entrepreneur Company ID], [Submission Month] & \, [Entrepreneur Company Pre Ignition Financials].Bookkeeper, [Entrepreneur Company Pre Ignition Financials].[Submission Month], [Entrepreneur Company Pre Ignition Financials].[Submission Year], MonthLkUp.[Month Number] FROM [Entrepreneur Company Pre Ignition Financials], [MonthLkUp]

Qry Report Bookkeeper Tracker

Type: Select

SELECT [Qry Count Companies Assigned by Bookkeeper].[Delivery Location], [Qry Count Companies Assigned by Bookkeeper].[RC Bookkeeper Assigned], [Qry Count Companies Assigned by Bookkeeper].[Their Own Bookkeeper], [Qry Count Companies Assigned by Bookkeeper].[Number Assigned], IIf(IsNull([Number Submitted]),0,[Number Submitted]), [Number Assigned]-[Submitted], IIf(IsNull([Complete Submissions]),0,[Complete Submissions]), IIf(IsNull([Incomplete Submissions]),0,[Incomplete Submissions]), IIf(IsNull([Under Query Submissions]),0,[Under Query Submissions]), IIf(IsNull([Number Submitted]) Or [Number Submitted]=0,0,[Complete]/[Number Subm, IIf(IsNull([Number Submitted]) Or [Number Submitted]=0,0,([Incomplete]+[Under Qu, IIf(IsNull([Previous Incomplete Submissions]),0,[Previous Incomplete Submissions FROM [Qry Count Companies Assigned by Bookkeeper], [SubQry Rpt Tracker Count Current Submissions by Bookkeeper], [SubQry Rpt Tracker Count Current Complete Subs by Bookkeeper], [SubQry Rpt Tracker Count Current Incomplete Subs by Bookkeeper], [SubQry Rpt Tracker Count Previous Incomplete Subs by Bookkeeper], [SubQry Rpt Tracker Count Current Under Query Subs by Bookkeeper]

Qry Report Bookkeeping Compliance All Delivery Locations

Type: Select

SELECT [Delivery Locations].[Delivery Location ID], [Delivery Locations].[Delivery Location], [Qry Get Companies Not Non Graduate].[Company Status ID], IIf(IsNull([Submissions].[Submission Year]),Null,IIf(IsNull([Month Number]),Null, [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[Entrepreneur Company ID], [Qry Get Companies Not Non Graduate].[Company Name], IIf([Own Bookkeeper]=True,\, [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Submission Year], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Submission Month], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Submission Status], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Sort Order], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Days Since Change], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Date Status Changed] FROM [Qry Get Companies Not Non Graduate], [SubQry Rpt Bookkeeping Compliance All Delivery Locations], [Delivery Locations], [Qry Get Last Submission ID by Company], [Submissions], [MonthLkUp]

Qry Report Bookkeeping Compliance by Company

Type: Select

SELECT [Temp Compliance by Company].[Delivery Location ID], [Temp Compliance by Company].[Delivery Location], [Temp Compliance by Company].[RC Bookkeeper Assigned], [Temp Compliance by Company].[Entrepreneur Company ID], [Temp Compliance by Company].[Company Name], [Temp Compliance by Company].[Their Own Bookkeeper], [Temp Compliance by Company].SubmissionDate, [Temp Compliance by Company].[Submission Status], [Temp Compliance by Company].[Issue New Permanent Staff], [Temp Compliance by Company].[Issue YTD Does Not Match] FROM [Temp Compliance by Company]

Qry Report Bookkeeping Compliance by Delivery Location

Type: Select

SELECT [Delivery Locations].[Delivery Location ID], [Delivery Locations].[Delivery Location], [Qry Get Companies Not Non Graduate].[Company Status ID], IIf(IsNull([Submissions].[Submission Year]),Null,IIf(IsNull([Month Number]),Null, [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[Entrepreneur Company ID], [Qry Get Companies Not Non Graduate].[Company Name], IIf([Own Bookkeeper]=True,\, [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Submission Year], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Submission Month], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Submission Status], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Sort Order], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Days Since Change], [SubQry Rpt Bookkeeping Compliance All Delivery Locations].[Date Status Changed] FROM [Qry Get Companies Not Non Graduate], [Delivery Locations], [SubQry Rpt Bookkeeping Compliance All Delivery Locations], [Qry Get Last Submission ID by Company], [Submissions], [MonthLkUp]

Qry Report Books Not Submitted Both Bookkeepers

Type: Select

SELECT [Qry Get Companies Assigned Both Bookkeepers].[Delivery Location], [Qry Get Companies Assigned Both Bookkeepers].[RC Bookkeeper Assigned], [Qry Get Companies Assigned Both Bookkeepers].[Company Name], IIf([Own Bookkeeper]=True,\ FROM [SubQry Rpt Books Not Submitted Raizcorp Bookkeeper], [Qry Get Companies Assigned Both Bookkeepers] WHERE ((([SubQry Rpt Books Not Submitted Raizcorp Bookkeeper].[Entrepreneur Company ID

Qry Report Books Not Submitted Raizcorp Bookkeeper

Type: Select

SELECT [Qry Get Companies Assigned Raizcorp Bookkeeper].[Delivery Location], [Qry Get Companies Assigned Raizcorp Bookkeeper].[RC Bookkeeper Assigned], [Qry Get Companies Assigned Raizcorp Bookkeeper].[Company Name] FROM [Qry Get Companies Assigned Raizcorp Bookkeeper], [SubQry Rpt Books Not Submitted Raizcorp Bookkeeper] WHERE ((([SubQry Rpt Books Not Submitted Raizcorp Bookkeeper].[Entrepreneur Company ID

Qry Report Companies Assigned

Type: Select

SELECT [Qry Get Companies Not Non Graduate].[Entrepreneur Company ID], [Qry Get Companies Not Non Graduate].[Company Status ID], [Delivery Locations].[Delivery Location], [Qry Get Companies Not Non Graduate].[Company Delivery Location ID], [Qry Get Companies Not Non Graduate].[Company Name], IIf([Own Bookkeeper]=True,\, [Qry Get Companies Not Non Graduate].[Date RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[Entrepreneur Company ID], Submissions.[Submission Month], [Submission Month] & \, IIf(IsNull([Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd(\ FROM [Delivery Locations], [Qry Get Last Submission ID by Company], [Submissions], [MonthLkUp], [Qry Get Companies Not Non Graduate]

Qry Report Current Escalated to PM

Type: Select

SELECT Submissions.[Submission ID], [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[Company Status ID], Submissions.[Submission Status ID], [Qry Get Companies Not Non Graduate].[Company Name], 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([Submissions].[Date Status Changed]),DateDiff(\ FROM [Submissions], [Submission Status], [MonthLkUp], [Qry Get Companies Not Non Graduate] WHERE ((([Qry Get Companies Not Non Graduate].[Company Status ID])<>4) AND ((Submissio

Qry Report Current Outstanding Submissions

Type: Select

SELECT Submissions.[Date Created], [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[Company Status ID], Submissions.[Submission Status ID], [Qry Get Companies Not Non Graduate].[Company Name], Submissions.[Submission Year], Submissions.[Submission Month], [Submission Month] & \, IIf(IsNull([Submission Year]),\, [Submission Status].[Submission Status], Submissions.[Date Status Changed], [Submission Status].[Sort Order] FROM [Submissions], [Submission Status], [MonthLkUp], [Qry Get Companies Not Non Graduate] WHERE ((([Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned]) Is Not Null) A

Qry Report Current Queries with Entrepreneurs

Type: Select

SELECT Submissions.[Submission ID], [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Qry Get Companies Not Non Graduate].[Company Status ID], Submissions.[Submission Status ID], [Qry Get Companies Not Non Graduate].[Company Name], 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([Submissions].[Date Status Changed]),DateDiff(\ FROM [Submissions], [Submission Status], [MonthLkUp], [Qry Get Companies Not Non Graduate] WHERE ((([Qry Get Companies Not Non Graduate].[Company Status ID])<>4) AND ((Submissio

Qry Report ESD ESD Update Tab

Type: Select

SELECT [Qry Get Last Programme Year Pillar by Principal Project].[Principal Project Pil, [Entrepreneur Company].[Entrepreneur Company ID], [Qry Get Last Programme Year Pillar by Principal Project].[BBBEE Pillar], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Brief Description of Business], [Entrepreneur Company].[Percentage Black Owned], [Entrepreneur Company].[Percentage Women Black Owned], [Business Address 1] & IIf(IsNull([Business Address 2]),\, [Qry Get Last Programme Year Pillar by Principal Project].[Total Programme Amoun, IIf(IsNull([Total Allocated]),0,[Total Allocated]), [Qry Get Last Programme Year Pillar by Principal Project].[Allocated Amount], IIf(IsNull([Total Programme Amount]),0,[Total Programme Amount])-IIf(IsNull([Tot, [Qry Get Last Programme Year Pillar by Principal Project].[Principal Project ID] FROM [Entrepreneur Company], [Qry Get Last Programme Year Pillar by Principal Project], [Qry Sum Total Allocated by Entrepreneur Programme Year] WHERE ((([Qry Get Last Programme Year Pillar by Principal Project].[Principal Project 

Qry Report ESD Exits and Replacements Tab

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Qry Get Last Programme Year Pillar by Principal Project].[BBBEE Pillar], [Entrepreneur Company].[Company Name], Products.Product, [Qry Get Last Programme Year Pillar by Principal Project].[Contract Start Date], [Qry Get Last Programme Year Pillar by Principal Project].[Date Status Changed], DateDiff(\ FROM [Entrepreneur Company], [Qry Get Last Programme Year Pillar by Principal Project], [Products], [NonGraduateReason], [CompanyStatus], [CompanyProgrammeYearStatus], [Entrepreneur Company Principal Projects], [Entrepreneur Company Programme Years], [Entrepreneur Company], [Qry Sum Total Allocated by Entrepreneur Programme Year] WHERE ((([Qry Get Last Programme Year Pillar by Principal Project].[Company Programme 

Qry Report ESD Futures Tab

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Qry Get Last Programme Year Pillar by Principal Project].[Entrepreneur Company , Entrepreneurs.[Recommended Principal Project ID] FROM [Entrepreneur Company], [Qry Get Last Programme Year Pillar by Principal Project], [Entrepreneurs] WHERE ((([Qry Get Last Programme Year Pillar by Principal Project].[Entrepreneur Compa

Qry Report ESD Graduation Likelyhood Tab

Type: Select

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Qry Get Last Programme Year Pillar by Principal Project].[BBBEE Pillar], [Entrepreneur Company].[Company Name], Products.Product, [Qry Get Last Programme Year Pillar by Principal Project].[Programme Year] FROM [Entrepreneur Company], [Qry Get Last Programme Year Pillar by Principal Project], [Products], [NonGraduateReason], [CompanyStatus], [CompanyProgrammeYearStatus], [Qry Sum Total Allocated by Entrepreneur Programme Year] WHERE ((([Qry Get Last Programme Year Pillar by Principal Project].[Principal Project 

Qry Report Financial Detail

Type: Select

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]

Qry Report Financial Summary

Type: Select

SELECT [SubQry Company List Criteria].[Distribution Model ID], [Entrepreneur Company].[Company Status ID], [Entrepreneur Company].[RC Bookkeeper Assigned], IIf(IsNull([Submission Year]),Null,IIf(IsNull([Month Number]),Null,DateAdd(\, [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Delivery Locations].[Delivery Location], CompanyStatus.Status, Products.Product, [Entrepreneur Company Programme Years].[Programme Year], [Entrepreneur Company Programme Years].[Contract Start Date], [Entrepreneur Company Programme Years].[Ignition Date], Round(IIf(IsNull([Total PI Turnover]),0,IIf(IsNull([Number of PI Entries]),0,[To, Round(IIf(IsNull([PI Gross Profit]),0,IIf(IsNull([Number of PI Entries]),0,[PI G, Round(IIf(IsNull([PI Net Profit]),0,IIf(IsNull([Number of PI Entries]),0,[PI Net, Round(IIf(IsNull([Total PI Salaries]),0,IIf(IsNull([Number of PI Entries]),0,[To, Round(IIf(IsNull([Total PI Net Asset Value]),0,IIf(IsNull([Number of PI Entries], IIf(IsNull([Last PI Directors]),0,[Last PI Directors]), IIf(IsNull([Last PI Permanent Staff]),0,[Last PI Permanent Staff]), IIf(IsNull([Last PI Contract Staff]),0,[Last PI Contract Staff]), [Qry Sum Submission Financials by Company].[Total Sub Turnover], [Qry Sum Submission Financials by Company].[Sub Gross Profit], [Qry Sum Submission Financials by Company].[Sub Net Profit], [Qry Sum Submission Financials by Company].[Total Sub Salaries], [Qry Sum Submission Financials by Company].[Total Sub Net Asset Value], Round(IIf(IsNull([Total Sub Turnover]),0,IIf(IsNull([Number of Sub Entries]),0,[, Round(IIf(IsNull([Sub Gross Profit]),0,IIf(IsNull([Number of Sub Entries]),0,[Su, Round(IIf(IsNull([Sub Net Profit]),0,IIf(IsNull([Number of Sub Entries]),0,[Sub , Round(IIf(IsNull([Total Sub Salaries]),0,IIf(IsNull([Number of Sub Entries]),0,[, Round(IIf(IsNull([Total Sub Net Asset Value]),0,IIf(IsNull([Number of Sub Entrie, IIf(IsNull([Last Sub Directors]),0,[Last Sub Directors]), IIf(IsNull([Last Sub Permanent Staff]),0,[Last Sub Permanent Staff]), IIf(IsNull([Last Sub Contract Staff]),0,[Last Sub Contract Staff]), IIf([Avg PI Turnover]<0,(([Avg Sub Turnover]-[Avg PI Turnover])/[Avg PI Turnover, IIf([Avg PI Gross Profit]<0,(([Avg Sub Gross Profit]-[Avg PI Gross Profit])/[Avg, IIf([Avg PI Net Profit]<0,(([Avg Sub Net Profit]-[Avg PI Net Profit])/[Avg PI Ne, IIf([Avg PI Salaries]<0,(([Avg Sub Salaries]-[Avg PI Salaries])/[Avg PI Salaries, IIf([Avg PI Net Asset Value]<0,(([Avg Sub Net Asset Value]-[Avg PI Net Asset Val FROM [Entrepreneur Company], [Qry Get Last Submission ID by Company], [Submissions], [MonthLkUp], [SubQry Company List Criteria], [Delivery Locations], [Qry Get Last Ignition Date by Company], [Entrepreneur Company Programme Years], [Products], [CompanyStatus], [Qry Get Last Submission Job Entry by Company], [Qry Count Pre-Ignition Financial Entries by Company], [Qry Count Submission Financial Complete Entries by Company], [Qry Sum Pre-Ignition Financials by Company], [Qry Sum Submission Financials by Company], [Qry Get Last Pre-Ignition Job Entry by Company] WHERE ((([Entrepreneur Company].[Company Status ID])=1 Or ([Entrepreneur Company].[Com

Qry Report Principal Projects Purchased ED vs SD S2S

Type: Select

SELECT [SubQry Purchased ED vs SD Report S2S].[Principal Project ID], [SubQry Purchased ED vs SD Report S2S].[Client Tier], [SubQry Purchased ED vs SD Report S2S].[Principal Project], [SubQry Purchased ED vs SD Report S2S].FYE, IIf(IsNull([Number ED Allocated]),0,[Number ED Allocated]), IIf(IsNull([Number SD Allocated]),0,[Number SD Allocated]), IIf(IsNull([Number Companies Bought From]),0,[Number Companies Bought From]), IIf(IsNull([Total Purchased]),0,[Total Purchased]) FROM [SubQry Purchased ED vs SD Report S2S], [Qry Count Number ED Allocated by Principal Project Pillar], [Qry Sum ED or SD Amount Purchased by Principal Project], [Qry Count Number SD Allocated by Principal Project Pillar], [Qry Count ED or SD Companies Bought From by Principal Project]

Qry Report Principal Projects Purchased ED vs SD SDM

Type: Select

SELECT [SubQry Purchased ED vs SD Report SDM].[Principal Project ID], [SubQry Purchased ED vs SD Report SDM].[Client Tier], [SubQry Purchased ED vs SD Report SDM].[Principal Project], [SubQry Purchased ED vs SD Report SDM].FYE, IIf(IsNull([Number ED Allocated]),0,[Number ED Allocated]), IIf(IsNull([Number SD Allocated]),0,[Number SD Allocated]), IIf(IsNull([Number Companies Bought From]),0,[Number Companies Bought From]), IIf(IsNull([Total Purchased]),0,[Total Purchased]) FROM [SubQry Purchased ED vs SD Report SDM], [Qry Count Number ED Allocated by Principal Project Pillar], [Qry Sum ED or SD Amount Purchased by Principal Project], [Qry Count Number SD Allocated by Principal Project Pillar], [Qry Count ED or SD Companies Bought From by Principal Project]

Qry Report Principal Spend by Company

Type: Select

SELECT [Entrepreneur Company].[Company Name], Principals.Principal, [SubQry Rpt Sum Principal Spend by Company].[Total Principal Spend] FROM [Principals], [SubQry Rpt Sum Principal Spend by Company], [Entrepreneur Company]

Qry Report Principal Spend by Delivery Location

Type: Select

SELECT [Delivery Locations].[Delivery Location], Principals.Principal, [SubQry Rpt Sum Principal Spend by Delivery Location].[Total Principal Spend] FROM [SubQry Rpt Sum Principal Spend by Delivery Location], [Delivery Locations], [Principals]

Qry Report Principal Spend by Principal and Company One Month

Type: Select

SELECT Submissions.[Submission Month], Submissions.[Submission Year], Principals.Principal, [Entrepreneur Company].[Company Name], [Principal Project Pillars].[BBBEE Pillar], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Entrepreneur Company Principal Projects], [Entrepreneur Company], [Submissions], [Submissions Principal Spend], [Principal Project Pillars], [Principal Projects], [Principals], [Entrepreneur Company Programme Years] WHERE (((Submissions.[Submission Month])=[Forms]![Frm Reports Month Year Dialog]![Subm

Qry Report Principal Spend by Principal YTD

Type: Select

SELECT Submissions.[Submission Year], Principals.Principal, Sum([Submissions Principal Spend].[Principal Spend]) FROM [Entrepreneur Company Principal Projects], [Submissions], [Submissions Principal Spend], [Principal Project Pillars], [Principal Projects], [Principals], [Entrepreneur Company Programme Years]

Qry Report Principal Spend Tracking

Type: Select

SELECT [Submissions Principal Spend].[Entrepreneur Company Principal Project ID], Submissions.[Submission Year], Submissions.[Submission Month], MonthLkUp.[Month Number], Sum([Submissions Principal Spend].[Principal Spend]) FROM [Submissions], [Submissions Principal Spend], [MonthLkUp]

Qry Report SDM Opal Shift

Type: Select

SELECT [SubQry Rpt SDM Opal Shift Get Principals].[Principal ID], [SubQry Rpt SDM Opal Shift Get Principals].Principal, [SubQry Rpt SDM Opal Shift Sum Previous Month Spend by Principal].[Submission Mo, IIf(IsNull([Previous Principal Spend]),0,[Previous Principal Spend]), [SubQry Rpt SDM Opal Shift Sum Current Month Spend by Principal].[Submission Mon, IIf(IsNull([Current Principal Spend]),0,[Current Principal Spend]), [Current Spend]-[Previous Spend] FROM [SubQry Rpt SDM Opal Shift Get Principals], [SubQry Rpt SDM Opal Shift Sum Current Month Spend by Principal], [SubQry Rpt SDM Opal Shift Sum Previous Month Spend by Principal]

Qry Report Submission Detail by Company

Type: Select

SELECT Submissions.[Submission ID], Submissions.[Entrepreneur Company ID], Submissions.[Date Books Submitted], [Submission Month] & \, Submissions.Bookkeeper FROM [Submissions]

Qry Submission List

Type: Select

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]

Qry SubRpt Submission Status History

Type: Select

SELECT [Submissions Status History].[Submission ID], [Submissions Status History].[Submission Status ID], [Submission Status].[Submission Status], [Submissions Status History].[Date Status Changed], [Submissions Status History].[Status Modified By], [Submission Status].[Sort Order] FROM [Submissions Status History], [Submission Status]

Qry Sum ED or SD Amount Purchased by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], Sum([Submissions Principal Spend].[Principal Spend]) FROM [Submissions Principal Spend], [Entrepreneur Company Principal Projects], [Entrepreneur Company Programme Years], [Principal Project Pillars] WHERE ((([Principal Project Pillars].[BBBEE Pillar])=\"ED\" Or ([Principal Project Pil

Qry Sum Pre-Ignition Financials by Company

Type: Select

SELECT [Entrepreneur Company Pre Ignition Financials].[Entrepreneur Company ID], Sum([Entrepreneur Company Pre Ignition Financials].Turnover), Sum(IIf(IsNull([Turnover]),0,[Turnover])-IIf(IsNull([Cost of Sales]),0,[Cost of , Sum((IIf(IsNull([Turnover]),0,[Turnover])-IIf(IsNull([Cost of Sales]),0,[Cost of, Sum([Entrepreneur Company Pre Ignition Financials].Salaries), Sum([Entrepreneur Company Pre Ignition Financials].[Net Asset Value]) FROM [Entrepreneur Company Pre Ignition Financials]

Qry Sum Submission Financials by Company

Type: Select

SELECT Submissions.[Entrepreneur Company ID], Submissions.[Submission Status ID], Sum(Submissions.Turnover), Sum(IIf(IsNull([Turnover]),0,[Turnover])-IIf(IsNull([Cost of Sales]),0,[Cost of , Sum((IIf(IsNull([Turnover]),0,[Turnover])-IIf(IsNull([Cost of Sales]),0,[Cost of, Sum(Submissions.Salaries), Sum(Submissions.[Net Asset Value]) FROM [Submissions]

Qry Sum Total Allocated by Entrepreneur Programme Year

Type: Select

SELECT [Entrepreneur Company Principal Projects].[Entrepreneur Company Programme Years , Sum([Entrepreneur Company Principal Projects].[Allocated Amount]) FROM [Entrepreneur Company Principal Projects]

Qry Sum Total Sponsored by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], Sum([Principal Project Pillars].[Amount Sponsored]) FROM [Principal Project Pillars]

qryLinkODBC

Type: Select

SELECT zstblODBC_db.Driver, zstblODBC_db.ServerName, zstblODBC_db.DBName, zstblODBC_db.Authentication, zstblODBC_db.UID, zstblODBC_db.PWD, zstblODBC_tables.Hidden, zstblODBC_tables.TableName, zstblODBC_tables.SourceTableName, zstblODBC_tables.AfterDDL FROM [zstblODBC_db], [zstblODBC_tables] WHERE (((zstblODBC_db.SelectDB)=True) AND ((zstblODBC_tables.Link)=True))

SubQry Company List Criteria

Type: Select

SELECT Entrepreneurs.[Distribution Model ID], Entrepreneurs.[Entrepreneur Company ID] FROM [Entrepreneurs], [Amber Distribution Models], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Amber Products] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])<>6

SubQry Count ED or SD Companies Bought From by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], [Entrepreneur Company Programme Years].[Entrepreneur Company ID] FROM [Submissions Principal Spend], [Entrepreneur Company Principal Projects], [Entrepreneur Company Programme Years], [Principal Project Pillars] WHERE ((([Principal Project Pillars].[BBBEE Pillar])=\"ED\" Or ([Principal Project Pil

SubQry Get Last Complete Submission by Company

Type: Select

SELECT Submissions.[Entrepreneur Company ID], Submissions.[Submission ID], DateSerial([Submission Year],[Month Number],1) FROM [Submissions], [MonthLkUp]

SubQry Purchased ED vs SD Report S2S Criteria

Type: Select

SELECT [Principal Projects].[Principal Project ID], [Principal] & \, [Client Tiers].[Client Tier], Principals.FYE FROM [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals], [Client Tiers], [Entrepreneur Company], [Entrepreneurs] WHERE ((([Principal Project Pillars].[BBBEE Pillar])<>\"SD\") AND (([Entrepreneur Comp

SubQry Purchased ED vs SD Report S2S

Type: Select

SELECT [SubQry Purchased ED vs SD Report S2S Criteria].[Principal Project ID], [SubQry Purchased ED vs SD Report S2S Criteria].[Principal Project], [SubQry Purchased ED vs SD Report S2S Criteria].[Client Tier], [SubQry Purchased ED vs SD Report S2S Criteria].FYE FROM [SubQry Purchased ED vs SD Report SDM], [SubQry Purchased ED vs SD Report S2S Criteria] WHERE ((([SubQry Purchased ED vs SD Report SDM].[Principal Project ID]) Is Null))

SubQry Purchased ED vs SD Report SDM

Type: Select

SELECT [Principal Projects].[Principal Project ID], [Principal] & \, [Client Tiers].[Client Tier], Principals.FYE FROM [Principal Project Pillars], [Principal Projects], [Principals], [Client Tiers], [Qry Get Principal Projects for Purchased ED vs SD Report] WHERE ((([Principal Project Pillars].[BBBEE Pillar])=\"SD\"))

SubQry Rpt Bookkeeping Compliance All Delivery Locations

Type: Select

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

SubQry Rpt Bookkeeping Compliance by Company

Type: Select

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

SubQry Rpt Books Not Submitted Raizcorp Bookkeeper

Type: Select

SELECT Submissions.[Entrepreneur Company ID], Submissions.[Submission Month], Submissions.[Submission Year] FROM [Submissions] WHERE (((Submissions.[Submission Month])=Forms![Frm Reports Books Not Submitted Dialog

SubQry Rpt SDM Opal Shift Get Principals

Type: Select

-- Unable to parse query definition

SubQry Rpt SDM Opal Shift Sum Current Month Spend by Principal

Type: Select

SELECT [Principal Projects].[Principal ID], Principals.Principal, [Principal Projects].[Client Tier ID], Submissions.[Submission Year], Submissions.[Submission Month], Sum([Submissions Principal Spend].[Principal Spend]) FROM [Entrepreneur Company Principal Projects], [Submissions], [Submissions Principal Spend], [Principal Project Pillars], [Principal Projects], [Principals], [Entrepreneur Company Programme Years], [MonthLkUp]

SubQry Rpt SDM Opal Shift Sum Previous Month Spend by Principal

Type: Select

SELECT [Principal Projects].[Principal ID], Principals.Principal, [Principal Projects].[Client Tier ID], Submissions.[Submission Year], Submissions.[Submission Month], Sum([Submissions Principal Spend].[Principal Spend]) FROM [Entrepreneur Company Principal Projects], [Submissions], [Submissions Principal Spend], [Principal Project Pillars], [Principal Projects], [Principals], [Entrepreneur Company Programme Years], [MonthLkUp]

SubQry Rpt Sum Principal Spend by Company

Type: Select

SELECT Submissions.[Submission Month], Submissions.[Submission Year], Submissions.[Entrepreneur Company ID], [Principal Projects].[Principal ID], Sum([Submissions Principal Spend].[Principal Spend]) FROM [Submissions], [Submissions Principal Spend], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects]

SubQry Rpt Sum Principal Spend by Delivery Location

Type: Select

SELECT Submissions.[Submission Month], Submissions.[Submission Year], [Entrepreneur Company].[Company Delivery Location ID], [Principal Projects].[Principal ID], Sum([Submissions Principal Spend].[Principal Spend]) FROM [Submissions], [Submissions Principal Spend], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Entrepreneur Company]

SubQry Rpt Tracker Count Current Complete Subs by Bookkeeper

Type: Select

SELECT [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Delivery Locations].[Delivery Location], IIf([Own Bookkeeper]=True,\, Count(Submissions.[Submission ID]) FROM [Submissions], [Submission Status], [MonthLkUp], [Qry Get Companies Not Non Graduate], [Delivery Locations] WHERE (((Submissions.[Submission Year])=Forms![Frm Reports Month Year Dialog]![Submiss

SubQry Rpt Tracker Count Current Incomplete Subs by Bookkeeper

Type: Select

SELECT [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Delivery Locations].[Delivery Location], IIf([Own Bookkeeper]=True,\, Count(Submissions.[Submission ID]) FROM [Submissions], [Submission Status], [MonthLkUp], [Qry Get Companies Not Non Graduate], [Delivery Locations] WHERE (((Submissions.[Submission Year])=Forms![Frm Reports Month Year Dialog]![Submiss

SubQry Rpt Tracker Count Current Submissions by Bookkeeper

Type: Select

SELECT [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Delivery Locations].[Delivery Location], IIf([Own Bookkeeper]=True,\, Count(Submissions.[Entrepreneur Company ID]), Submissions.[Submission Year], Submissions.[Submission Month] FROM [Submissions], [Submission Status], [MonthLkUp], [Qry Get Companies Not Non Graduate], [Delivery Locations]

SubQry Rpt Tracker Count Current Under Query Subs by Bookkeeper

Type: Select

SELECT [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Delivery Locations].[Delivery Location], IIf([Own Bookkeeper]=True,\, Count(Submissions.[Submission ID]) FROM [Submissions], [Submission Status], [MonthLkUp], [Qry Get Companies Not Non Graduate], [Delivery Locations] WHERE (((Submissions.[Submission Year])=Forms![Frm Reports Month Year Dialog]![Submiss

SubQry Rpt Tracker Count Previous Incomplete Subs by Bookkeeper

Type: Select

SELECT [Qry Get Companies Not Non Graduate].[RC Bookkeeper Assigned], [Delivery Locations].[Delivery Location], IIf([Own Bookkeeper]=True,\, Count(Submissions.[Submission ID]) FROM [Submissions], [Submission Status], [MonthLkUp], [Qry Get Companies Not Non Graduate], [Delivery Locations] WHERE (((Submissions.[Submission Month])<>Forms![Frm Reports Month Year Dialog]![Submi