purple - Implementation Details
VBA Modules
Form_Add and Edit Areas of Operation (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Areas of Operation.txt
Lines: 60
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 Assessment Marker (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Assessment Marker.txt
Lines: 60
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 Business Premises (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Business Premises.txt
Lines: 62
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 Channel Partners (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Channel Partners.txt
Lines: 70
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 Contract Type (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Contract Type.txt
Lines: 62
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 Country (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Country.txt
Lines: 20
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Delivery Location (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Delivery Location.txt
Lines: 75
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Distribution Model (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Distribution Model.txt
Lines: 76
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 Division (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Division.txt
Lines: 72
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 Entrepreneur Arize First Meeting (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Entrepreneur Arize First Meeting.txt
Lines: 103
Procedures
Private Sub Form_BeforeInsert(Cancel As Integer)
Private Sub Form_Close()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_Open(Cancel As Integer)
Private Sub OK_to_Continue_AfterUpdate()
Private Sub Part_V_Researched_Applicants_Website_AfterUpdate()
Private Sub Print_the_Report_Click()
Private Sub RecommendationsEntrepreneur_Click()
Form_Add and Edit Entrepreneur Candidate Recommendation (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Entrepreneur Candidate Recommendation.txt
Lines: 63
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeInsert(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Entrepreneur Company (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Entrepreneur Company.txt
Lines: 54
Procedures
Private Sub Brief_Description_of_Business_AfterUpdate()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_Close()
Form_Add and Edit Entrepreneurs (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Entrepreneurs.txt
Lines: 543
Procedures
Public Function ThereIsADuplicate() As Boolean
Public Sub CalculateDateOfBirth()
- ⚠️ Contains GoTo statements
Private Sub AddCompany_Click()
Private Sub ArchiveResults_Click()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements; High branching (9 If statements)
Private Sub Delivery_Location_ID_AfterUpdate()
Private Sub Distribution_Model_ID_AfterUpdate()
Private Sub Division_ID_AfterUpdate()
Private Sub EditFirstMeeting_Click()
Private Sub EditViewStatusHistory_Click()
Private Sub Financial_Literacy_Result_AfterUpdate()
Private Sub Form_BeforeInsert(Cancel As Integer)
- ⚠️ High branching (6 If statements)
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Form_Close()
- ⚠️ High branching (13 If statements)
Private Sub Form_Open(Cancel As Integer)
- ⚠️ High branching (8 If statements)
Private Sub SA_Id_Number_AfterUpdate()
Private Sub Personal_Audit_Score_AfterUpdate()
Private Sub PrintEOI_Click()
Private Sub Recommended_Product_ID_AfterUpdate()
- ⚠️ Uses SendKeys
Private Sub SAID_AfterUpdate()
Private Sub Style_Questionnaire_Score_AfterUpdate()
Private Sub ViewEditHistory_Click()
Private Sub ViewFirstMeeting_Click()
Form_Add and Edit Lead Format (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Lead Format.txt
Lines: 62
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 Lead Source (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Lead Source.txt
Lines: 62
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 Lead Type (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Lead Type.txt
Lines: 31
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Form_Close()
Form_Add and Edit Personal Audit Result (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Personal Audit Result.txt
Lines: 60
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 Pipeline (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Pipeline.txt
Lines: 160
Procedures
Private Sub AddToPipeline_Click()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub CopyPipeline_Click()
Private Sub DeletePipeline_Click()
Private Sub Form_Close()
Private Sub Form_Open(Cancel As Integer)
Private Sub InPipelineList_KeyDown(KeyCode As Integer, Shift As Integer)
Private Sub PrintPipeline_Click()
Private Sub The_Pipeline_ID_AfterUpdate()
Form_Add and Edit Principal Project Status (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Principal Project Status.txt
Lines: 40
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Principal Project (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Principal Project.txt
Lines: 39
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_Close()
Private Sub Form_Open(Cancel As Integer)
Form_Add and Edit Principal (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Principal.txt
Lines: 29
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_Close()
Private Sub Form_Open(Cancel As Integer)
Form_Add and Edit Process Status (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Process Status.txt
Lines: 20
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Process Step (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Process Step.txt
Lines: 75
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Product (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Product.txt
Lines: 34
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Form_Close()
Form_Add and Edit Progress Category (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Progress Category.txt
Lines: 75
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Province (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Province.txt
Lines: 66
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Race (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Race.txt
Lines: 66
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Source Category (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Source Category.txt
Lines: 66
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Source Detail (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Source Detail.txt
Lines: 67
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Style Questions Weighting (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Style Questions Weighting.txt
Lines: 66
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Termination Reason (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Termination Reason.txt
Lines: 67
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Turnover Category (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Turnover Category.txt
Lines: 67
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Unqualified Reason (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Unqualified Reason.txt
Lines: 67
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add and Edit Urgency Result (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Urgency Result.txt
Lines: 60
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 User Modules (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit User Modules.txt
Lines: 30
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeInsert(Cancel As Integer)
Private Sub Form_Close()
Form_Add and Edit Users (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Users.txt
Lines: 85
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Form_Close()
Private Sub LEVEL_AfterUpdate()
- ⚠️ High branching (7 If statements)
Form_Add and Edit Years in Business (Form)
File: ms_access_files\purple\Forms\Frm Add and Edit Years in Business.txt
Lines: 67
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub NewRecord_Click()
- ⚠️ Contains GoTo statements
Form_Add Pipeline Name Dialog (Form)
File: ms_access_files\purple\Forms\Frm Add Pipeline Name Dialog.txt
Lines: 78
Procedures
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Alerts List (Form)
File: ms_access_files\purple\Forms\Frm Alerts List.txt
Lines: 25
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub PrintReport_Click()
Form_Alerts Report Dialog (Form)
File: ms_access_files\purple\Forms\Frm Alerts Report Dialog.txt
Lines: 44
Procedures
Private Sub Form_Close()
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Change Password (Form)
File: ms_access_files\purple\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_Check Duplicates (Form)
File: ms_access_files\purple\Forms\Frm Check Duplicates.txt
Lines: 108
Procedures
Public Sub UpdateNumber()
Private Sub EntrepreneurList_DblClick(Cancel As Integer)
Private Sub EntrepreneurList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (9 If statements)
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_Open(Cancel As Integer)
Form_Detailed Movement Report Dialog (Form)
File: ms_access_files\purple\Forms\Frm Detailed Movement Report Dialog.txt
Lines: 68
Procedures
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements; High branching (6 If statements)
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Private Sub ReportType_AfterUpdate()
Form_Edit Entrepreneur Status (Form)
File: ms_access_files\purple\Forms\Frm Edit Entrepreneur Status.txt
Lines: 470
Procedures
Private Sub DisplayStatusNotes()
Private Sub SaveTheChanges()
- ⚠️ High branching (10 If statements)
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_Open(Cancel As Integer)
Private Sub Override_Status_Rules_AfterUpdate()
Private Sub Pipeline_ID_AfterUpdate()
Private Function MoreThanThreeFollowUp() As Boolean
Private Sub Process_Status_ID_AfterUpdate()
- ⚠️ High branching (59 If statements); Uses SendKeys; Large procedure (255 lines)
Form_Edit Second Entrepreneur (Form)
File: ms_access_files\purple\Forms\Frm Edit Second Entrepreneur.txt
Lines: 359
Procedures
Public Sub CalculateDateOfBirth()
- ⚠️ Contains GoTo statements
Private Sub AddCompany_Click()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements; High branching (9 If statements)
Private Sub Delivery_Location_ID_AfterUpdate()
Private Sub Distribution_Model_ID_AfterUpdate()
Private Sub Division_ID_AfterUpdate()
Private Sub EditFirstMeeting_Click()
Private Sub EditViewStatusHistory_Click()
Private Sub Financial_Literacy_Result_AfterUpdate()
Private Sub Form_BeforeInsert(Cancel As Integer)
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Form_Close()
- ⚠️ High branching (13 If statements)
Private Sub Form_Open(Cancel As Integer)
- ⚠️ High branching (7 If statements)
Private Sub SA_Id_Number_AfterUpdate()
Private Sub Personal_Audit_Score_AfterUpdate()
Private Sub PrintEOI_Click()
Private Sub Recommended_Product_ID_AfterUpdate()
Private Sub SAID_AfterUpdate()
Private Sub Style_Questionnaire_Score_AfterUpdate()
Private Sub ViewEditHistory_Click()
Form_Entrepreneur Active List (Form)
File: ms_access_files\purple\Forms\Frm Entrepreneur Active List.txt
Lines: 254
Procedures
Public Sub UpdateList()
- ⚠️ High branching (11 If statements)
Private Sub ClearFilters_Click()
Private Sub CriteriaCombo1_AfterUpdate()
Private Sub Dashboards_AfterUpdate()
- ⚠️ High branching (18 If statements)
Private Sub EntrepreneurList_DblClick(Cancel As Integer)
Private Sub EntrepreneurList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (6 If statements)
Private Sub EntrepreneurStatus_AfterUpdate()
Private Sub Filter1_AfterUpdate()
Private Sub Form_Activate()
Private Sub Form_Open(Cancel As Integer)
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub ReportMenu_Click()
Private Sub StrCriteria1_AfterUpdate()
Form_Entrepreneur Company List (Form)
File: ms_access_files\purple\Forms\Frm Entrepreneur Company List.txt
Lines: 160
Procedures
Public Sub UpdateList()
Private Sub AddCompany_Click()
Private Sub AddCompanyto_Entrepreneur_Click()
Private Sub CompanyList_AfterUpdate()
Private Sub CompanyList_DblClick(Cancel As Integer)
Private Sub CompanyList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (6 If statements)
Private Sub EntrepreneurList_KeyDown(KeyCode As Integer, Shift As Integer)
Private Sub Form_Close()
Private Sub Form_Open(Cancel As Integer)
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub StrCriteria1_AfterUpdate()
Form_Entrepreneur Digital Selection List (Form)
File: ms_access_files\purple\Forms\Frm Entrepreneur Digital Selection List.txt
Lines: 382
Procedures
Public Sub UpdateList()
- ⚠️ High branching (30 If statements); Large procedure (116 lines)
Private Sub ClearFilters_Click()
Private Sub CriteriaCombo1_AfterUpdate()
Private Sub CriteriaCombo2_AfterUpdate()
Private Sub Dashboards_AfterUpdate()
- ⚠️ High branching (18 If statements)
Private Sub EntrepreneurList_DblClick(Cancel As Integer)
Private Sub EntrepreneurList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (6 If statements)
Private Sub EntrepreneurStatus_AfterUpdate()
Private Sub Filter1_AfterUpdate()
- ⚠️ High branching (9 If statements)
Private Sub Filter2_AfterUpdate()
- ⚠️ High branching (9 If statements)
Private Sub Form_Activate()
Private Sub Form_Open(Cancel As Integer)
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub ReportMenu_Click()
Private Sub StrCriteria1_AfterUpdate()
Private Sub StrCriteria2_AfterUpdate()
Form_Entrepreneur Graduating List (Form)
File: ms_access_files\purple\Forms\Frm Entrepreneur Graduating List.txt
Lines: 263
Procedures
Public Sub UpdateList()
- ⚠️ High branching (12 If statements)
Private Sub ClearFilters_Click()
Private Sub CriteriaCombo1_AfterUpdate()
Private Sub Dashboards_AfterUpdate()
- ⚠️ High branching (18 If statements)
Private Sub EntrepreneurList_DblClick(Cancel As Integer)
Private Sub EntrepreneurList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (6 If statements)
Private Sub EntrepreneurStatus_AfterUpdate()
Private Sub Filter1_AfterUpdate()
- ⚠️ High branching (6 If statements)
Private Sub Form_Activate()
Private Sub Form_Open(Cancel As Integer)
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub ReportMenu_Click()
Private Sub StrCriteria1_AfterUpdate()
Form_Entrepreneur Ignition List (Form)
File: ms_access_files\purple\Forms\Frm Entrepreneur Ignition List.txt
Lines: 273
Procedures
Public Sub UpdateList()
- ⚠️ High branching (11 If statements)
Private Sub ClearFilters_Click()
Private Sub CriteriaCombo1_AfterUpdate()
Private Sub Dashboards_AfterUpdate()
- ⚠️ High branching (18 If statements)
Private Sub EntrepreneurList_DblClick(Cancel As Integer)
Private Sub EntrepreneurList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (6 If statements)
Private Sub EntrepreneurStatus_AfterUpdate()
Private Sub Filter1_AfterUpdate()
- ⚠️ High branching (9 If statements)
Private Sub Form_Activate()
Private Sub Form_Open(Cancel As Integer)
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub ReportMenu_Click()
Private Sub StrCriteria1_AfterUpdate()
Form_Entrepreneur List Report Dialog (Form)
File: ms_access_files\purple\Forms\Frm Entrepreneur List Report Dialog.txt
Lines: 1013
Procedures
Public Sub ExportEntrepreneurList(TheWhereStr As String)
- ⚠️ Contains GoTo statements; Large procedure (124 lines)
Public Sub ExportEntrepreneurPipelineList(TheWhereStr As String)
- ⚠️ Contains GoTo statements; Large procedure (124 lines)
Public Sub ExportEntrepreneurIgnitionList(TheWhereStr As String)
- ⚠️ Contains GoTo statements; Large procedure (131 lines)
Public Sub ExportEntrepreneurRaizcorpossiblesList(TheWhereStr As String)
- ⚠️ Contains GoTo statements; Large procedure (102 lines)
Public Sub ExportEntrepreneurActiveList(TheWhereStr As String)
- ⚠️ Contains GoTo statements; Large procedure (134 lines)
Public Sub ExportEntrepreneurPartSponsorshipList(TheWhereStr As String)
- ⚠️ Contains GoTo statements; Large procedure (104 lines)
Public Sub ExportEntrepreneurGraduatingList(TheWhereStr As String)
- ⚠️ Contains GoTo statements
Public Sub ExportEntrepreneurPurpleMeetingList()
- ⚠️ Contains GoTo statements
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements; High branching (21 If statements)
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Entrepreneur List (Form)
File: ms_access_files\purple\Forms\Frm Entrepreneur List.txt
Lines: 478
Procedures
Public Sub UpdateList()
- ⚠️ High branching (35 If statements); Large procedure (132 lines)
Private Sub AddEntrepreneur_Click()
Private Sub ChangePassword_Click()
Private Sub ClearFilters_Click()
Private Sub CriteriaCombo1_AfterUpdate()
Private Sub CriteriaCombo2_AfterUpdate()
Private Sub Dashboards_AfterUpdate()
- ⚠️ High branching (18 If statements)
Private Sub DuplicateFunction_Click()
Private Sub EntrepreneurList_DblClick(Cancel As Integer)
Private Sub EntrepreneurList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (6 If statements)
Private Sub EntrepreneurStatus_AfterUpdate()
Private Sub Filter1_AfterUpdate()
- ⚠️ High branching (11 If statements)
Private Sub Filter2_AfterUpdate()
- ⚠️ High branching (11 If statements)
Private Sub Form_Activate()
Private Sub Form_Open(Cancel As Integer)
- ⚠️ High branching (7 If statements)
Private Sub ImportFunction_Click()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub MaintenanceFunction_Click()
Private Sub OpenSecondEP_Click()
Private Sub ReportMenu_Click()
Private Sub StrCriteria1_AfterUpdate()
Private Sub StrCriteria2_AfterUpdate()
Form_Entrepreneur Part Sponsorship List (Form)
File: ms_access_files\purple\Forms\Frm Entrepreneur Part Sponsorship List.txt
Lines: 254
Procedures
Public Sub UpdateList()
- ⚠️ High branching (11 If statements)
Private Sub ClearFilters_Click()
Private Sub CriteriaCombo1_AfterUpdate()
Private Sub Dashboards_AfterUpdate()
- ⚠️ High branching (18 If statements)
Private Sub EntrepreneurList_DblClick(Cancel As Integer)
Private Sub EntrepreneurList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (6 If statements)
Private Sub EntrepreneurStatus_AfterUpdate()
Private Sub Filter1_AfterUpdate()
Private Sub Form_Activate()
Private Sub Form_Open(Cancel As Integer)
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub ReportMenu_Click()
Private Sub StrCriteria1_AfterUpdate()
Form_Entrepreneur Pipeline List (Form)
File: ms_access_files\purple\Forms\Frm Entrepreneur Pipeline List.txt
Lines: 382
Procedures
Public Sub UpdateList()
- ⚠️ High branching (29 If statements); Large procedure (116 lines)
Private Sub ClearFilters_Click()
Private Sub CriteriaCombo1_AfterUpdate()
Private Sub CriteriaCombo2_AfterUpdate()
Private Sub Dashboards_AfterUpdate()
- ⚠️ High branching (18 If statements)
Private Sub EntrepreneurList_DblClick(Cancel As Integer)
Private Sub EntrepreneurList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (6 If statements)
Private Sub EntrepreneurStatus_AfterUpdate()
Private Sub Filter1_AfterUpdate()
- ⚠️ High branching (9 If statements)
Private Sub Filter2_AfterUpdate()
- ⚠️ High branching (9 If statements)
Private Sub Form_Activate()
Private Sub Form_Open(Cancel As Integer)
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub ReportMenu_Click()
Private Sub StrCriteria1_AfterUpdate()
Private Sub StrCriteria2_AfterUpdate()
Form_Entrepreneur Purple List (Form)
File: ms_access_files\purple\Forms\Frm Entrepreneur Purple List.txt
Lines: 101
Procedures
Private Sub Dashboards_AfterUpdate()
- ⚠️ High branching (18 If statements)
Private Sub Form_Activate()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_Open(Cancel As Integer)
Private Sub RefreshCounts_Click()
Private Sub ReportMenu_Click()
Form_Entrepreneur Raizcorpossibles List (Form)
File: ms_access_files\purple\Forms\Frm Entrepreneur Raizcorpossibles List.txt
Lines: 253
Procedures
Public Sub UpdateList()
- ⚠️ High branching (11 If statements)
Private Sub ClearFilters_Click()
Private Sub CriteriaCombo1_AfterUpdate()
Private Sub Dashboards_AfterUpdate()
- ⚠️ High branching (18 If statements)
Private Sub EntrepreneurList_DblClick(Cancel As Integer)
Private Sub EntrepreneurList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (6 If statements)
Private Sub EntrepreneurStatus_AfterUpdate()
Private Sub Filter1_AfterUpdate()
Private Sub Form_Activate()
Private Sub Form_Open(Cancel As Integer)
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub ReportMenu_Click()
Private Sub StrCriteria1_AfterUpdate()
Form_Entrepreneur Summary Report Dialog (Form)
File: ms_access_files\purple\Forms\Frm Entrepreneur Summary Report Dialog.txt
Lines: 55
Procedures
Private Sub Form_Close()
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Private Sub ReportType_AfterUpdate()
Form_Import Entrepreneur Dialog (Form)
File: ms_access_files\purple\Forms\Frm Import Entrepreneur Dialog.txt
Lines: 1626
Procedures
Public Sub ImportShortTemplate1()
- ⚠️ Contains GoTo statements
Public Sub ImportShortTemplate2()
- ⚠️ Contains GoTo statements
Public Sub ImportLongTemplate1()
- ⚠️ Contains GoTo statements; High branching (6 If statements); Large procedure (109 lines)
Public Sub ImportLongTemplate2()
- ⚠️ Contains GoTo statements; High branching (6 If statements); Large procedure (116 lines)
Public Sub ImportShortTemplate1NotFormsite()
- ⚠️ Contains GoTo statements
Public Sub ImportShortTemplate2NotFormsite()
- ⚠️ Contains GoTo statements
Public Sub ImportLongTemplate1NotFormsite()
- ⚠️ Contains GoTo statements; High branching (7 If statements); Large procedure (104 lines)
Public Sub ImportLongTemplate2NotFormsite()
- ⚠️ Contains GoTo statements; High branching (7 If statements); Large procedure (111 lines)
Public Sub ImportShortTemplate1A()
- ⚠️ Contains GoTo statements; High branching (6 If statements); Large procedure (103 lines)
Public Sub ImportShortTemplate2A()
- ⚠️ Contains GoTo statements; High branching (6 If statements); Large procedure (107 lines)
Public Sub ImportLongTemplate1A()
- ⚠️ Contains GoTo statements; High branching (8 If statements); Large procedure (120 lines)
Public Sub ImportLongTemplate2A()
- ⚠️ Contains GoTo statements; High branching (8 If statements); Large procedure (127 lines)
Public Sub CalculateDateOfBirth(SAIdNumber As String, DateOfBirth As Date)
- ⚠️ Contains GoTo statements
Public Sub ImportPitchandPolishTemplate()
- ⚠️ Contains GoTo statements; High branching (7 If statements); Large procedure (102 lines)
Public Sub ImportPurpleREMSTemplate()
- ⚠️ Contains GoTo statements; High branching (8 If statements); Large procedure (124 lines)
Private Sub BrowseForFile_Click()
Private Sub CancelButton_Click()
Private Sub DoTheImport_Click()
- ⚠️ Contains GoTo statements; High branching (18 If statements)
Form_Lead Detail Report Date Dialog (Form)
File: ms_access_files\purple\Forms\Frm Lead Detail Report Date Dialog.txt
Lines: 298
Procedures
Public Sub ExportEntrepreneursByLeadTypetoExcel()
- ⚠️ Contains GoTo statements; High branching (6 If statements); Large procedure (202 lines)
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements; High branching (7 If statements)
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Private Sub ReportType_AfterUpdate()
Form_Lead Report Date Dialog (Form)
File: ms_access_files\purple\Forms\Frm Lead Report Date Dialog.txt
Lines: 141
Procedures
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements; High branching (9 If statements)
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Private Sub ReportType_AfterUpdate()
Form_Lead Type List (Form)
File: ms_access_files\purple\Forms\Frm Lead Type List.txt
Lines: 92
Procedures
Public Sub UpdateList()
Private Sub AddLeadType_Click()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub LeadTypeList_DblClick(Cancel As Integer)
Private Sub LeadTypeList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (6 If statements)
Private Sub StrCriteria1_AfterUpdate()
Form_Lead Type Principal Project Report Dialog (Form)
File: ms_access_files\purple\Forms\Frm Lead Type Principal Project Report Dialog.txt
Lines: 45
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\purple\Forms\Frm Maintenance Menu.txt
Lines: 158
Procedures
Private Sub Areas_of_Operation_Click()
Private Sub Assessment_Markers_Click()
Private Sub Business_Premises_Click()
Private Sub Channel_Partners_Click()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub Contract_Type_Click()
Private Sub Country_Click()
Private Sub Delivery_Location_Click()
Private Sub Delivery_Method_Click()
Private Sub Division_Click()
Private Sub Entrepreneur_Sourced_From_Click()
Private Sub EntrepreneurCompanies_Click()
Private Sub Lead_Format_Click()
Private Sub Lead_Source_Click()
Private Sub LeadType_Click()
Private Sub MassAllocation_Click()
Private Sub Personal_Audit_Result_Click()
Private Sub Pipelines_Click()
Private Sub Principal_Click()
Private Sub Principal_Project_Status_Click()
Private Sub Process_Step_Click()
Private Sub ProcessStatus_Click()
Private Sub Product_Click()
Private Sub Progress_Category_Click()
Private Sub Province_Click()
Private Sub Race_Click()
Private Sub Source_Category_Click()
Private Sub Source_Detail_Click()
Private Sub StyleQuestionsWeighting_Click()
Private Sub Termination_Reason_Click()
Private Sub Turnover_Category_Click()
Private Sub Unqualified_Reason_Click()
Private Sub Urgency_Result_Click()
Private Sub Users_Click()
Private Sub Years_in_Business_Click()
Form_Marketing Lead Report Date Dialog (Form)
File: ms_access_files\purple\Forms\Frm Marketing Lead Report Date Dialog.txt
Lines: 106
Procedures
Public Sub PopulateTempLeads()
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements; High branching (8 If statements)
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Opening Dialog (Form)
File: ms_access_files\purple\Forms\Frm Opening Dialog.txt
Lines: 112
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()
Form_Pipeline Movement Report Dialog (Form)
File: ms_access_files\purple\Forms\Frm Pipeline Movement Report Dialog.txt
Lines: 50
Procedures
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Principal List (Form)
File: ms_access_files\purple\Forms\Frm Principal List.txt
Lines: 104
Procedures
Public Sub UpdateList()
Private Sub Form_Open(Cancel As Integer)
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub PrincipalList_AfterUpdate()
Private Sub PrincipalList_DblClick(Cancel As Integer)
Private Sub PrincipalList_KeyDown(KeyCode As Integer, Shift As Integer)
Private Sub PrincipalProjectList_DblClick(Cancel As Integer)
Private Sub PrincipalProjectList_KeyDown(KeyCode As Integer, Shift As Integer)
Private Sub StrCriteria1_AfterUpdate()
Form_Principal Project Report Dialog (Form)
File: ms_access_files\purple\Forms\Frm Principal Project Report Dialog.txt
Lines: 46
Procedures
Private Sub Form_Close()
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Principal Project Status Report Dialog (Form)
File: ms_access_files\purple\Forms\Frm Principal Project Status Report Dialog.txt
Lines: 45
Procedures
Private Sub Form_Close()
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Principal Report Date Dialog (Form)
File: ms_access_files\purple\Forms\Frm Principal Report Date Dialog.txt
Lines: 79
Procedures
Private Sub Form_Close()
Private Sub Form_Open(Cancel As Integer)
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements; High branching (6 If statements)
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Product List (Form)
File: ms_access_files\purple\Forms\Frm Product List.txt
Lines: 99
Procedures
Private Sub AddProduct_Click()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub EditPipeline_Click()
Private Sub ProductList_AfterUpdate()
Private Sub ProductList_DblClick(Cancel As Integer)
Private Sub ProductList_KeyDown(KeyCode As Integer, Shift As Integer)
- ⚠️ High branching (8 If statements)
Form_Recommended Principal Report Dialog (Form)
File: ms_access_files\purple\Forms\Frm Recommended Principal Report Dialog.txt
Lines: 53
Procedures
Private Sub Form_Close()
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Report Menu (Form)
File: ms_access_files\purple\Forms\Frm Report Menu.txt
Lines: 489
Procedures
Private Sub Average_Days_in_Pipeline_Click()
Private Sub AverageDaysPerStep_Click()
Private Sub AvgDaysPipelineTrendExport_Click()
Private Sub BEETaxExpiryReport_Click()
Private Sub BlueHeartEmailsNotSent_Click()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub DigitalProcess_Click()
Private Sub ContractExpiryReport_Click()
Private Sub ContractSignedorVAPacks_Click()
Private Sub Ctl48HourDetailExport_Click()
Private Sub DetailedMovementReportPrincipal_Click()
Private Sub EntrepreneurEditHistory_Click()
Private Sub EntrepreneurialAssessmentResults_Click()
Private Sub EntrepreneurialProfile_Click()
Private Sub EntrepreneurListReport_Click()
Private Sub EntrepreneurProfileMergeData_Click()
Private Sub EntrepreneursLeadType_Click()
Private Sub EntrepreneursModified_Click()
Private Sub EntrepreneurSummaryReport_Click()
Private Sub ExecLeadSummaryReport_Click()
Private Sub FirstMeetingPercentDropOff_Click()
Private Sub Form_Open(Cancel As Integer)
Private Sub HeadhuntingReport_Click()
Private Sub InvoiceRequestsReport_Click()
Private Sub LeadReport_Click()
Private Sub LeadReportDailyBreakdown_Click()
Private Sub LeadSummaryReport_Click()
Private Sub LeadSummaryReportRange_Click()
Private Sub LeadTypePrincipalAllocation_Click()
Private Sub ListBlankOwnedBy_Click()
Private Sub MarketingEOItoPassedPanelReport_Click()
Private Sub MarketingLeadReport_Click()
Private Sub MarketingLeadReportVersionTwo_Click()
Private Sub MarketingPreUnqualifiedLeads_Click()
Private Sub MoreThanThreeFollowUps_Click()
Private Sub MovementSummaryReport_Click()
Private Sub OpalEPbyPrincipalProject_Click()
Private Sub OpalEPSummarybyPrincipalProject_Click()
Private Sub Partner_Elite_Report_Click()
Private Sub PartSponsorshipReport_Click()
Private Sub P3GraduatesAtLeast5MonthsExited_Click()
Private Sub PanelsPasssedbyScout_Click()
Private Sub Principal_Report_Current_Pipeline_Detail_Click()
Private Sub PrincipalAllocationReportforPrincipal_Click()
Private Sub PrincipalPrettyReport_Click()
Private Sub PrincipalProjectAllocationReportbyBeneficiary_Click()
Private Sub PrincipalProjectInformation_Click()
Private Sub PurplePanelistsSummary_Click()
Private Sub PurplePanelResults_Click()
Private Sub QuartzLeadPhaseReport_Click()
Private Sub RAG_Report_Click()
Private Sub RaizcorpossiblesPartsponsorship_Click()
Private Sub RaizcorpPossibilitiesReport_Click()
Private Sub RecommendedPrincipalProjectAllocationReport_Click()
Private Sub ReportWriter_Click()
Private Sub SelectionActivityReportOverview_Click()
Private Sub SelectionActivityReportSummary_Click()
Private Sub SelectionDailyTeamActivityReport_Click()
Private Sub SelectionTeamActivityTimesReport_Click()
Private Sub SelectionTeamCallReport_Click()
Private Sub SelectionTeamTargetsReport_Click()
Private Sub SelectionTeamTargetSummaryReport_Click()
Private Sub SpecialReportWriter_Click()
Private Sub StepMovementReport_Click()
Private Sub Steps_Skipped_Error_Report_Click()
Private Sub TerminationAnalysisDataReport_Click()
Private Sub VAPacksRequired_Click()
Private Sub WorkshopAttendanceRegister_Click()
Form_Report Writer Dialog Sales (Form)
File: ms_access_files\purple\Forms\Frm Report Writer Dialog Sales.txt
Lines: 289
Procedures
Public Sub ExportTheReport()
- ⚠️ Contains GoTo statements; High branching (20 If statements); Large procedure (201 lines)
Private Sub ClearFilters_Click()
Private Sub Filter1_AfterUpdate()
Private Sub Form_Close()
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Report Writer Dialog (Form)
File: ms_access_files\purple\Forms\Frm Report Writer Dialog.txt
Lines: 368
Procedures
Public Sub ExportTheReport()
- ⚠️ Contains GoTo statements; High branching (35 If statements); Large procedure (230 lines)
Private Sub ClearFilters_Click()
Private Sub Filter1_AfterUpdate()
- ⚠️ High branching (6 If statements)
Private Sub Filter2_AfterUpdate()
- ⚠️ High branching (6 If statements)
Private Sub Form_Close()
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Reports Date Dialog (Form)
File: ms_access_files\purple\Forms\Frm Reports Date Dialog.txt
Lines: 60
Procedures
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements; High branching (7 If statements)
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Reports Date Distribution Model Dialog (Form)
File: ms_access_files\purple\Forms\Frm Reports Date Distribution Model Dialog.txt
Lines: 49
Procedures
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Reports Print Digital Process Single Date Dialog (Form)
File: ms_access_files\purple\Forms\Frm Reports Print Digital Process Single Date Dialog.txt
Lines: 49
Procedures
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Form_Reports Print Export Date Dialog (Form)
File: ms_access_files\purple\Forms\Frm Reports Print Export Date Dialog.txt
Lines: 55
Procedures
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements; High branching (6 If statements)
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Reports Print Export Dialog (Form)
File: ms_access_files\purple\Forms\Frm Reports Print Export Dialog.txt
Lines: 42
Procedures
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Reports Print Export Single Date Dialog (Form)
File: ms_access_files\purple\Forms\Frm Reports Print Export Single Date Dialog.txt
Lines: 49
Procedures
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Reports Single Date Dialog (Form)
File: ms_access_files\purple\Forms\Frm Reports Single Date Dialog.txt
Lines: 45
Procedures
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Reports Single Date Division Dialog (Form)
File: ms_access_files\purple\Forms\Frm Reports Single Date Division Dialog.txt
Lines: 51
Procedures
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Selection Team Targets Report Dialog (Form)
File: ms_access_files\purple\Forms\Frm Selection Team Targets Report Dialog.txt
Lines: 632
Procedures
Public Sub ExportSelectionTeamTargetsToExcel()
- ⚠️ Contains GoTo statements; High branching (6 If statements); Large procedure (288 lines)
Public Sub ExportSelectionTeamTargetSummaryToExcel()
- ⚠️ Contains GoTo statements; Large procedure (133 lines)
Public Sub PopulateEntrepreneurStepTable()
Public Sub ExportHeadhuntingReportToExcel()
- ⚠️ Contains GoTo statements
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_Selection Team Time Report Dialog (Form)
File: ms_access_files\purple\Forms\Frm Selection Team Time Report Dialog.txt
Lines: 62
Procedures
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Private Sub ReportType_AfterUpdate()
Form_Step Movement Report Dialog (Form)
File: ms_access_files\purple\Forms\Frm Step Movement Report Dialog.txt
Lines: 147
Procedures
Public Sub PopulateStepTable()
- ⚠️ High branching (6 If statements)
Private Sub Form_Close()
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements; High branching (6 If statements)
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Private Sub ReportType_AfterUpdate()
Form_User List (Form)
File: ms_access_files\purple\Forms\Frm User List.txt
Lines: 164
Procedures
Public Sub UpdateList()
Private Sub AddModule_Click()
Private Sub AddUser_Click()
Private Sub ClearFilters_Click()
Private Sub CriteriaCombo1_AfterUpdate()
Private Sub Filter1_AfterUpdate()
Private Sub Form_Open(Cancel As Integer)
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Private Sub ModuleList_DblClick(Cancel As Integer)
Private Sub ModuleList_KeyDown(KeyCode As Integer, Shift As Integer)
Private Sub StrCriteria1_AfterUpdate()
Private Sub UserList_AfterUpdate()
Private Sub UserList_DblClick(Cancel As Integer)
Private Sub UserList_KeyDown(KeyCode As Integer, Shift As Integer)
Form_View Entrepreneur Digital First Meeting (Form)
File: ms_access_files\purple\Forms\Frm View Entrepreneur Digital First Meeting.txt
Lines: 31
Procedures
Private Sub Form_BeforeInsert(Cancel As Integer)
Private Sub Form_Close()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Form_View Entrepreneur Digital Style Questionnaire (Form)
File: ms_access_files\purple\Forms\Frm View Entrepreneur Digital Style Questionnaire.txt
Lines: 31
Procedures
Private Sub Form_BeforeInsert(Cancel As Integer)
Private Sub Form_Close()
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Form_View Entrepreneur Edit History (Form)
File: ms_access_files\purple\Forms\Frm View Entrepreneur Edit History.txt
Lines: 20
Procedures
Private Sub CloseFOrm_Click()
- ⚠️ Contains GoTo statements
Form_Workshop Attendance Register Report Dialog (Form)
File: ms_access_files\purple\Forms\Frm Workshop Attendance Register Report Dialog.txt
Lines: 50
Procedures
Private Sub Form_Close()
Private Sub OKButton_Click()
- ⚠️ Contains GoTo statements
Private Sub CancelButton_Click()
- ⚠️ Contains GoTo statements
Form_SubFrm Entrepreneur Company Areas of Operation (Form)
File: ms_access_files\purple\Forms\SubFrm Entrepreneur Company Areas of Operation.txt
Lines: 41
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Form_SubFrm Entrepreneur Company Commodities (Form)
File: ms_access_files\purple\Forms\SubFrm Entrepreneur Company Commodities.txt
Lines: 41
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Form_SubFrm Entrepreneur Company Ignition Dates Display Only (Form)
File: ms_access_files\purple\Forms\SubFrm Entrepreneur Company Ignition Dates Display Only.txt
Lines: 54
Procedures
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Private Sub Form_BeforeUpdate(Cancel As Integer)
Form_SubFrm Entrepreneur Company Non Participant Shareholders (Form)
File: ms_access_files\purple\Forms\SubFrm Entrepreneur Company Non Participant Shareholders.txt
Lines: 20
Procedures
Private Sub DeleteRec_Click()
Form_SubFrm Entrepreneur Company (Form)
File: ms_access_files\purple\Forms\SubFrm Entrepreneur Company.txt
Lines: 24
Procedures
Private Sub Brief_Description_of_Business_AfterUpdate()
Form_SubFrm Entrepreneur First Meeting Date (Form)
File: ms_access_files\purple\Forms\SubFrm Entrepreneur First Meeting Date.txt
Lines: 41
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Form_SubFrm Entrepreneur Notes (Form)
File: ms_access_files\purple\Forms\SubFrm Entrepreneur Notes.txt
Lines: 41
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Form_SubFrm Entrepreneur Profile Presented To (Form)
File: ms_access_files\purple\Forms\SubFrm Entrepreneur Profile Presented To.txt
Lines: 45
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Private Sub Principal_Project_ID_AfterUpdate()
Form_SubFrm Entrepreneur Purple Panelists (Form)
File: ms_access_files\purple\Forms\SubFrm Entrepreneur Purple Panelists.txt
Lines: 41
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
Form_SubFrm Principal Project Pillar Sponsor Elements (Form)
File: ms_access_files\purple\Forms\SubFrm Principal Project Pillar Sponsor Elements.txt
Lines: 32
Procedures
Private Sub DeleteRec_Click()
Private Sub Element_Type_AfterUpdate()
Private Sub Form_BeforeInsert(Cancel As Integer)
Private Sub Sponsorship_Amount_AfterUpdate()
Form_SubFrm Principal Project Pillar Sub Products (Form)
File: ms_access_files\purple\Forms\SubFrm Principal Project Pillar Sub Products.txt
Lines: 24
Procedures
Private Sub DeleteRec_Click()
Private Sub Form_BeforeInsert(Cancel As Integer)
Form_SubFrm Principal Project Pillars (Form)
File: ms_access_files\purple\Forms\SubFrm Principal Project Pillars.txt
Lines: 50
Procedures
Private Sub AddPillar_Click()
Private Sub DeleteRec_Click()
- ⚠️ Contains GoTo statements
Form_SubFrm Product Distribution Models (Form)
File: ms_access_files\purple\Forms\SubFrm Product Distribution Models.txt
Lines: 20
Procedures
Private Sub DeleteRec_Click()
Form_SubFrm Product Divisions (Form)
File: ms_access_files\purple\Forms\SubFrm Product Divisions.txt
Lines: 20
Procedures
Private Sub DeleteRec_Click()
basRelink (Standard)
File: ms_access_files\purple\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 CompactTablesMain() 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
ExportModule (Standard)
File: ms_access_files\purple\Modules\ExportModule.bas
Lines: 341
Procedures
Public Sub ExportAllCode()
Public Sub ExportAllCodeToFolder(outputFolder As String, Optional includeQueries As Boolean = True)
Private Function ExportModules(folderPath As String) As Integer
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function ExportForms(folderPath As String) As Integer
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function ExportReports(folderPath As String) As Integer
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function ExportMacros(folderPath As String) As Integer
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function ExportQueries(folderPath As String) As Integer
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function ExportTableSchemas(folderPath As String) As Integer
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function GetFieldTypeName(fieldType As Integer) As String
Private Function SanitizeFileName(fileName As String) As String
Private Sub CreateFolderIfNotExists(folderPath As String)
- ⚠️ Uses On Error Resume Next; Contains GoTo statements
Private Function BrowseForFolder(prompt As String) As String
Global (Standard)
File: ms_access_files\purple\Modules\Global.bas
Lines: 100
Procedures
Public Function DigiReport(Optional DteFrm As Date, Optional DteTo As Date)
Public Function SQLRun(SQLString As String, Optional IgnoreError As Boolean = False, Optional IsQuery As Boolean = False) As Boolean
- ⚠️ Contains GoTo statements
Public Function CleanTbl(sTblNme As String, Optional sWhere As String = "") As Boolean
Public Function IsTable(sTablenme As String) As Boolean
Mod Export Excel (Standard)
File: ms_access_files\purple\Modules\Mod Export Excel.bas
Lines: 5438
Procedures
Public Sub ExportDetailedPrincipalToExcel()
- ⚠️ Contains GoTo statements
Public Sub ExportPrincipalSupplierListAndMarketingToExcel()
- ⚠️ Contains GoTo statements; High branching (14 If statements); Large procedure (467 lines)
Public Sub ExportRaizcorpPossibilitiesToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements; High branching (9 If statements); Large procedure (846 lines)
Public Sub ExportMarketingLeadsVersionTwoToExcel()
- ⚠️ Contains GoTo statements
Public Sub ExportMarketingLeadTypePrincipalAllocationToExcel()
- ⚠️ Contains GoTo statements; Large procedure (129 lines)
Public Sub Export48HoursToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements; Large procedure (214 lines)
Public Sub ExportRAGToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements; High branching (19 If statements); Large procedure (393 lines)
Public Sub ExportPartnerEliteToExcel()
- ⚠️ Contains GoTo statements; High branching (7 If statements); Large procedure (269 lines)
Public Sub ExportRecommendedPrincipalProjectAllocationToExcel()
- ⚠️ Contains GoTo statements; Large procedure (153 lines)
Public Sub ExportPrincipalProjectAllocationbyEntrepreneurToExcel()
- ⚠️ Contains GoTo statements; Large procedure (110 lines)
Public Sub ExportOpalPrincipalProjectsToExcel()
- ⚠️ Contains GoTo statements; Large procedure (109 lines)
Public Sub ExportOpalRaizcorpossiblesToExcel()
- ⚠️ Contains GoTo statements; High branching (7 If statements); Large procedure (148 lines)
Public Sub ExportAvgDaysPipelineTrendbyDistModel()
- ⚠️ Contains GoTo statements; High branching (8 If statements); Large procedure (187 lines)
Public Sub ExportOpalPrincipalProjectSummarytoExcel()
- ⚠️ Contains GoTo statements; High branching (15 If statements); Large procedure (321 lines)
Public Sub ExportPurplePanelistSummaryToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements
Public Sub ExportWorkshopAttendanceRegisterToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements; Large procedure (131 lines)
Public Sub ExportEntrepreneursInvoiceRequestedToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements
Public Sub ExportMoreThan3FollowUpToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements; Large procedure (130 lines)
Public Sub ExportMarketingPreUnqualifiedLeadsToExcel()
- ⚠️ Contains GoTo statements
Public Sub ExportMarketingEOItoPassedPanelToExcel()
- ⚠️ Contains GoTo statements
Public Sub ExportTerminationAnalysisDataToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements; High branching (12 If statements); Large procedure (267 lines)
Public Sub ExportQuartzLeadsbyPhaseToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements
Public Sub ExportPercentDropoffAfterFristMeetingToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements
Public Sub ExportBlueHearEmailNotSentToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements
Public Sub ExportAverageDaysPerStepToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements; Large procedure (170 lines)
Public Sub ExportPurplePanelResultsToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements; High branching (7 If statements); Large procedure (138 lines)
Public Sub ExportPreviousStepTerminatedReadyAllocated()
- ⚠️ Contains GoTo statements; High branching (8 If statements); Large procedure (184 lines)
Public Sub ExportCompanyProfileMergeToExcel(FromAuto As Boolean, Optional TheFileName As String)
- ⚠️ Contains GoTo statements; High branching (12 If statements); Large procedure (215 lines)
Public Sub SaveIt()
Mod Populate Temp Table (Standard)
File: ms_access_files\purple\Modules\Mod Populate Temp Table.bas
Lines: 341
Procedures
Public Sub PopulateAvgDaysStepTable()
Public Sub PopulateRaizcorpPossiblesTempTable()
Public Sub PopulatePurpleMeetingStepTable()
Public Sub PopulateTempStepsSkippedErrors()
- ⚠️ Contains GoTo statements; High branching (11 If statements); Large procedure (123 lines)
Public Sub PopulateStepTableForSummaryReport()
Mod Utilities (Standard)
File: ms_access_files\purple\Modules\Mod Utilities.bas
Lines: 282
Procedures
Public Sub FrmProductListProductList_AfterUpdate()
Public Sub AllocateSpecificEPs()
Public Sub DeleteEntrepreneur(EPID As Long)
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()
Module1 (Standard)
File: ms_access_files\purple\Modules\Module1.bas
Lines: 1
SQL Queries
Find duplicates for Engage UUID
Type: Select
SELECT [Engage UUID].[UUID], [Engage UUID].[REMS ID], [Engage UUID].[Source] FROM [Engage UUID] WHERE ((([Engage UUID].[UUID]) In (SELECT [UUID] FROM [Engage UUID] As Tmp GROUP BY [U
Find duplicates for Entrepreneurs
Type: Select
SELECT Entrepreneurs.[Entrepreneur Company ID], Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Process Status ID], Entrepreneurs.[First Name], Entrepreneurs.[Surname] FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Entrepreneur Company ID]) In (SELECT [Entrepreneur Company ID]
Find duplicates for Qry Report Termination Analysis Data
Type: Select
SELECT [Qry Report Termination Analysis Data].[Entrepreneur ID], [Qry Report Termination Analysis Data].[Status], [Qry Report Termination Analysis Data].[Entrepreneur], [Qry Report Termination Analysis Data].[Company Name] FROM [Qry Report Termination Analysis Data] WHERE ((([Qry Report Termination Analysis Data].[Entrepreneur ID]) In (SELECT [Entrepr
JB Digital Process Status
Type: Select
SELECT ProcessStatus.[Selection Type], ProcessStatus.[Step Number], ProcessStatus.Status, ProcessStatus.[Sort Order] FROM [ProcessStatus] WHERE (((ProcessStatus.[Selection Type])=2))
JB Entrepreneurs With No Pipeline
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Division ID], Entrepreneurs.[Pipeline ID], Entrepreneurs.[Process Status ID], ProcessStatus.Status, ProcessStatus.[Step Number], Entrepreneurs.[First Name], Entrepreneurs.Surname FROM [Entrepreneurs], [ProcessStatus] WHERE (((Entrepreneurs.[Pipeline ID]) Is Null) AND ((Entrepreneurs.[Process Status ID]
JB Qry Example of Report
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], Entrepreneurs.[Process Status ID], Entrepreneurs.[Date Status Changed], ProcessStatus.Status, ProcessStatus.[Sort Order], Pipelines.[Selection Type] FROM [Entrepreneurs], [ProcessStatus], [Pipelines] WHERE (((Entrepreneurs.[Date Record Created])>=#9/25/2022# And (Entrepreneurs.[Date Re
JB Qry Initialise UUID
Type: Delete
SELECT Entrepreneurs.[Entrepreneur ID], \, \ FROM [Entrepreneurs]
JB Qry Not Digital Pipeline
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[First Name], Entrepreneurs.Surname, ProcessStatus.[Selection Type], Pipelines.[Selection Type], Pipelines.Pipeline, ProcessStatus_1.Status, Entrepreneurs.[Date Status Changed] FROM [Entrepreneurs], [Entrepreneur Status History], [Pipelines], [ProcessStatus], [ProcessStatus]
JB Qry Raizcorpossibles with terminated or unqualified EPs
Type: Select
SELECT Entrepreneurs.[Process Status ID], ProcessStatus.Status, Entrepreneurs.[Date Status Changed], [Entrepreneur Company].[Company Status ID], CompanyStatus.Status, [Entrepreneur Company].[Date Status Changed], [Delivery Locations].[Delivery Location], [Entrepreneur Company].[Company Name], Entrepreneurs.[First Name], Entrepreneurs.Surname FROM [Entrepreneurs], [Entrepreneur Company], [ProcessStatus], [CompanyStatus], [Delivery Locations] WHERE (((Entrepreneurs.[Process Status ID])<>91) AND (([Entrepreneur Company].[Company
JB Reactivated EPs
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[First Name], Entrepreneurs.Surname, Entrepreneurs.[Date Record Created], [Entrepreneur Status History].[Process Status ID], [Entrepreneur Status History].[Date Status Changed], Entrepreneurs.[Process Status ID], Entrepreneurs.[Date Status Changed] FROM [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus] WHERE ((([Entrepreneur Status History].[Process Status ID])=29))
JB SubQry Get Ready For Allocation without History
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur ID] FROM [Entrepreneur Status History] WHERE ((([Entrepreneur Status History].[Process Status ID])<>91))
JB Update Date Status Changed Unallocated
Type: Update
SELECT [Entrepreneurs].[Date Status Changed], \ FROM [Entrepreneur Company], [Entrepreneurs] WHERE ((([Entrepreneur Company].[Company Status ID])=2) AND (([Entrepreneur Company].[
JB Update DO NOT USE IN DIGITAL
Type: Update
SELECT True FROM [Lead Types] WHERE ((([Lead Types].[Lead Type ID])=158 Or ([Lead Types].[Lead Type ID])=617 Or ([Le
JBQry Current Raizcorp Possibles by Delivery Location
Type: Select
SELECT [Entrepreneur Company].[Company Delivery Location ID], [Delivery Locations].[Delivery Location], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Entrepreneur Company ID], [Qry Get Division Dist Model Del Loc and Rec Info by Company].[Pipeline ID], [Entrepreneur Company].[Company Status ID] FROM [Delivery Locations], [Qry Get Division Dist Model Del Loc and Rec Info by Company], [Entrepreneur Company] WHERE ((([Qry Get Division Dist Model Del Loc and Rec Info by Company].[Pipeline ID])=
Jo Qry Uncontacted Followup Ready for Allocation
Type: Select
SELECT [Jo Qry Uncontacted Unfollow Reeady for Allocation].[Lead Type], Entrepreneurs.[First Name], Entrepreneurs.Surname, [Jo Qry Uncontacted Unfollow Reeady for Allocation].[Email Address], Entrepreneurs.Race, Entrepreneurs.[Identity Number], Entrepreneurs.Gender, Entrepreneurs.[Telephone Number], Entrepreneurs.[Delivery Location ID], Entrepreneurs.[Entrepreneur Company ID], [Jo Qry Uncontacted Unfollow Reeady for Allocation].[Information 4], [Jo Qry Uncontacted Unfollow Reeady for Allocation].[Process Status ID] FROM [Jo Qry Uncontacted Unfollow Reeady for Allocation], [Entrepreneurs]
Qry Application Versions
Type: Select
-- Unable to parse query definition
Qry Calculate Percent Headhunted Qualified by OwnedBy Date Range
Type: Select
SELECT [Qry Count Headhunted by OwnedBy Date Range].OwnedBy, IIf(IsNull([Total Headhunted]),0,[Total Headhunted]), IIf(IsNull([Headhunted Qualified]),0,[Headhunted Qualified]), IIf([Total HH]=0,0,IIf(IsNull([Headhunted Qualified]),0,[Headhunted Qualified])/ FROM [Qry Count Headhunted by OwnedBy Date Range], [Qry Count Headhunted Qualified by OwnedBy Date Range]
Qry Count Active Allocated Companies by Principal Project Pillar
Type: Select
SELECT [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company].[Company Status ID])=1 Or ([Entrepreneur Company].[Com
Qry Count Companies by PP Pillar Principal Report
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], [Principal Project Pillars].[BBBEE Pillar], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company].[Company Status ID])=1 Or ([Entrepreneur Company].[Com
Qry Count Companies by Principal Project Principal Report
Type: Select
SELECT vwPurpleCountCompaniesbyPrincipalProjectPrincipalReport.[Principal Project ID], Count(vwPurpleCountCompaniesbyPrincipalProjectPrincipalReport.[Entrepreneur Comp FROM [vwPurpleCountCompaniesbyPrincipalProjectPrincipalReport]
Qry Count Current Active Allocated Companies On Pgm by Prin Proj
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Principal Project Pillars], [Entrepreneur Company Principal Projects], [Entrepreneur Company Programme Years], [Entrepreneur Company] WHERE ((([Entrepreneur Company].[Company Status ID])=3) AND (([Entrepreneur Company Pr
Qry Count Current Active Companies by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=1)
Qry Count Current Active Companies Total
Type: Select
SELECT Count([SubQry Count Current Active Companies Total].[Entrepreneur Company ID]) FROM [SubQry Count Current Active Companies Total]
Qry Count Current Active Entrepreneurs by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=1)
Qry Count Current Active Entrepreneurs Total
Type: Select
SELECT Count([SubQry Count Current Active Entrepreneurs Total].[Entrepreneur ID]) FROM [SubQry Count Current Active Entrepreneurs Total]
Qry Count Current Entrepreneurs Allocated for Purple
Type: Select
SELECT Entrepreneurs.[Recommended Principal Project ID], [Entrepreneur Company].[Company Status ID], Entrepreneurs.[Process Status ID], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [Entrepreneur Company]
Qry Count Current Entrepreneurs by Step for Purple
Type: Select
SELECT Entrepreneurs.[Recommended Principal Project ID], ProcessStatus.[Step Number], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus]
Qry Count Current Exited Companies by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Principal Projects].[Replacement Status]) Is Null Or ([
Qry Count Current Exited Entrepreneurs by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company].[Company Status ID])=4) AND ((Entrepreneurs.[Process S
Qry Count Current Part Sponsorship by Delivery Location And Type
Type: Select
SELECT [Qry Report Part Sponsorship].[Company Delivery Location ID], [Delivery Locations].[Delivery Location], IIf(([Company Status ID]<>4) And ([Company Programme Year Status ID]<>6 Or [Comp, Count([Qry Report Part Sponsorship].[Entrepreneur Company ID]), Sum([Qry Report Part Sponsorship].[Amount Needed]) FROM [Delivery Locations], [Qry Report Part Sponsorship]
Qry Count Current Part Sponsorship by Delivery Location
Type: Select
SELECT [Qry Report Part Sponsorship].[Company Delivery Location ID], [Delivery Locations].[Delivery Location], Count([Qry Report Part Sponsorship].[Entrepreneur Company ID]), Sum([Qry Report Part Sponsorship].[Amount Needed]) FROM [Delivery Locations], [Qry Report Part Sponsorship]
Qry Count Current Raizcorp Possibles by Delivery Location
Type: Select
SELECT [Entrepreneur Company].[Company Delivery Location ID], [Delivery Locations].[Delivery Location], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Delivery Locations], [Qry Get Division Dist Model Del Loc and Rec Info by Company], [Entrepreneur Company] WHERE ((([Qry Get Division Dist Model Del Loc and Rec Info by Company].[Pipeline ID])=
Qry Count Delivery Locations Allowed by Principal Project
Type: Select
SELECT [Qry Get Delivery Locations Allowed by Principal Project].[Principal Project ID], Count([Qry Get Delivery Locations Allowed by Principal Project].[Delivery Locati FROM [Qry Get Delivery Locations Allowed by Principal Project]
Qry Count Entrepreneur Moved Last Week Digital Process
Type: Select
SELECT Count([SubQry Get Entrepreneur Moved Last Week].[Entrepreneur ID]) FROM [SubQry Get Entrepreneur Moved Last Week] WHERE ((([SubQry Get Entrepreneur Moved Last Week].[Selection Type])=2))
Qry Count Entrepreneur Moved Last Week Digitalby Delivery Loca
Type: Select
SELECT [SubQry Get Entrepreneur Moved Last Week].[Delivery Location ID], [SubQry Get Entrepreneur Moved Last Week].[Delivery Location], Count([SubQry Get Entrepreneur Moved Last Week].[Entrepreneur ID]) FROM [SubQry Get Entrepreneur Moved Last Week] WHERE ((([SubQry Get Entrepreneur Moved Last Week].[Selection Type])=2))
Qry Count Entrepreneur Moved Last Week Manuaby Delivery Location
Type: Select
SELECT [SubQry Get Entrepreneur Moved Last Week].[Delivery Location ID], [SubQry Get Entrepreneur Moved Last Week].[Delivery Location], Count([SubQry Get Entrepreneur Moved Last Week].[Entrepreneur ID]) FROM [SubQry Get Entrepreneur Moved Last Week] WHERE ((([SubQry Get Entrepreneur Moved Last Week].[Selection Type])=1))
Qry Count Entrepreneur Moved Last Week Manual Process
Type: Select
SELECT Count([SubQry Get Entrepreneur Moved Last Week].[Entrepreneur ID]) FROM [SubQry Get Entrepreneur Moved Last Week] WHERE ((([SubQry Get Entrepreneur Moved Last Week].[Selection Type])=1))
Qry Count Entrepreneur Steps 1 to 7 Digital by Delivery Location
Type: Select
SELECT vwPurpleGetEntrepreneursSteps1to7.[Delivery Location ID], vwPurpleGetEntrepreneursSteps1to7.[Distribution Model], vwPurpleGetEntrepreneursSteps1to7.[Delivery Location], Count(vwPurpleGetEntrepreneursSteps1to7.[Entrepreneur ID]) FROM [vwPurpleGetEntrepreneursSteps1to7] WHERE (((vwPurpleGetEntrepreneursSteps1to7.[Selection Type])=2))
Qry Count Entrepreneur Steps 1 to 7 Digital Process
Type: Select
SELECT Count(vwPurpleGetEntrepreneursSteps1to7.[Entrepreneur ID]) FROM [vwPurpleGetEntrepreneursSteps1to7] WHERE (((vwPurpleGetEntrepreneursSteps1to7.[Selection Type])=2))
Qry Count Entrepreneur Steps 1 to 7 Manual by Delivery Location
Type: Select
SELECT vwPurpleGetEntrepreneursSteps1to7.[Delivery Location ID], vwPurpleGetEntrepreneursSteps1to7.[Distribution Model], vwPurpleGetEntrepreneursSteps1to7.[Delivery Location], Count(vwPurpleGetEntrepreneursSteps1to7.[Entrepreneur ID]) FROM [vwPurpleGetEntrepreneursSteps1to7] WHERE (((vwPurpleGetEntrepreneursSteps1to7.[Selection Type])=1))
Qry Count Entrepreneur Steps 1 to 7 Manual Process
Type: Select
SELECT Count(vwPurpleGetEntrepreneursSteps1to7.[Entrepreneur ID]) FROM [vwPurpleGetEntrepreneursSteps1to7] WHERE (((vwPurpleGetEntrepreneursSteps1to7.[Selection Type])=1))
Qry Count Entrepreneurial Assessment Results
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[EA Date])>=[Forms]![Frm Reports Date Dialog]![StartDate] And (
Qry Count Entrepreneurial Assessment Retake Results
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[EA Retake Date])>=[Forms]![Frm Reports Date Dialog]![StartDate
Qry Count Entrepreneurs by Company for Projile
Type: Select
SELECT [Entrepreneur Company].[Entrepreneur Company ID], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneur Company], [Entrepreneurs] WHERE ((([Entrepreneur Company].[Company Status ID])=1 Or ([Entrepreneur Company].[Com
Qry Count Entrepreneurs by PP Pillar Principal Report
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], [Principal Project Pillars].[BBBEE Pillar], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company].[Company Status ID])=1 Or ([Entrepreneur Company].[Com
Qry Count Entrepreneurs by Principal Project Principal Report
Type: Select
SELECT [SubQry Count Entrepreneurs by Principal Project Principal Report].[Principal Pr, Count([SubQry Count Entrepreneurs by Principal Project Principal Report].[Entrep FROM [SubQry Count Entrepreneurs by Principal Project Principal Report]
Qry Count Entrepreneurs Pipeline Phase 1 by Delivery Location
Type: Select
SELECT Entrepreneurs.[Delivery Location ID], ProcessStep.Phase, Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus], [ProcessStep]
Qry Count Entrepreneurs Pipeline Phase 2 by Delivery Location
Type: Select
SELECT Entrepreneurs.[Delivery Location ID], ProcessStep.Phase, Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus], [ProcessStep]
Qry Count Entrepreneurs Pipeline Phase 3 by Delivery Location
Type: Select
SELECT Entrepreneurs.[Delivery Location ID], ProcessStep.Phase, Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus], [ProcessStep]
Qry Count Entreprenur Steps Total at 1 and 2
Type: Select
SELECT [Temp Entrepreneur Steps].OwnedBy, Count([Temp Entrepreneur Steps].[Record ID]) FROM [Temp Entrepreneur Steps] WHERE ((([Temp Entrepreneur Steps].[Step 1 Last Date]) Is Not Null) AND (([Temp Entrep
Qry Count Entreprenur Steps Total at 1 and 3
Type: Select
SELECT [Temp Entrepreneur Steps].OwnedBy, Count([Temp Entrepreneur Steps].[Record ID]) FROM [Temp Entrepreneur Steps] WHERE ((([Temp Entrepreneur Steps].[Step 1 Last Date]) Is Not Null) AND (([Temp Entrep
Qry Count Entreprenur Steps Total at 1 and 4
Type: Select
SELECT [Temp Entrepreneur Steps].OwnedBy, Count([Temp Entrepreneur Steps].[Record ID]) FROM [Temp Entrepreneur Steps] WHERE ((([Temp Entrepreneur Steps].[Step 1 Last Date]) Is Not Null) AND (([Temp Entrep
Qry Count Entreprenur Steps Total at 1 and 7
Type: Select
SELECT [Temp Entrepreneur Steps].OwnedBy, Count([Temp Entrepreneur Steps].[Record ID]) FROM [Temp Entrepreneur Steps] WHERE ((([Temp Entrepreneur Steps].[Step 1 Last Date]) Is Not Null) AND (([Temp Entrep
Qry Count Entreprenur Steps Total at 1 and 8
Type: Select
SELECT [Temp Entrepreneur Steps].OwnedBy, Count([Temp Entrepreneur Steps].[Record ID]) FROM [Temp Entrepreneur Steps] WHERE ((([Temp Entrepreneur Steps].[Step 1 Last Date]) Is Not Null) AND (([Temp Entrep
Qry Count Entreprenur Steps Total at 1
Type: Select
SELECT [Temp Entrepreneur Steps].OwnedBy, Count([Temp Entrepreneur Steps].[Record ID]) FROM [Temp Entrepreneur Steps] WHERE ((([Temp Entrepreneur Steps].[Step 1 Last Date]) Is Not Null))
Qry Count Entreprenur Steps Total at 2
Type: Select
SELECT [Temp Entrepreneur Steps].OwnedBy, Count([Temp Entrepreneur Steps].[Record ID]) FROM [Temp Entrepreneur Steps] WHERE ((([Temp Entrepreneur Steps].[Step 2 Last Date]) Is Not Null))
Qry Count Entreprenur Steps Total at 3
Type: Select
SELECT [Temp Entrepreneur Steps].OwnedBy, Count([Temp Entrepreneur Steps].[Record ID]) FROM [Temp Entrepreneur Steps] WHERE ((([Temp Entrepreneur Steps].[Step 3 Last Date]) Is Not Null))
Qry Count Entreprenur Steps Total at 4
Type: Select
SELECT [Temp Entrepreneur Steps].OwnedBy, Count([Temp Entrepreneur Steps].[Record ID]) FROM [Temp Entrepreneur Steps] WHERE ((([Temp Entrepreneur Steps].[Step 4 Last Date]) Is Not Null))
Qry Count Entreprenur Steps Total at 7
Type: Select
SELECT [Temp Entrepreneur Steps].OwnedBy, Count([Temp Entrepreneur Steps].[Record ID]) FROM [Temp Entrepreneur Steps] WHERE ((([Temp Entrepreneur Steps].[Step 7 Last Date]) Is Not Null))
Qry Count Entreprenur Steps Total at 8
Type: Select
SELECT [Temp Entrepreneur Steps].OwnedBy, Count([Temp Entrepreneur Steps].[Record ID]) FROM [Temp Entrepreneur Steps] WHERE ((([Temp Entrepreneur Steps].[Step 8 Last Date]) Is Not Null))
Qry Count Exited Companies by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=2
Qry Count Exited Need Replacement by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Principal Projects], [Entrepreneur Company Programme Years] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=5)
Qry Count Headhunted by OwnedBy Date Range
Type: Select
SELECT [SubQry Count Headhunted by OwnedBy Date Range Criteria].OwnedBy, Count([SubQry Count Headhunted by OwnedBy Date Range Criteria].[Entrepreneur ID] FROM [SubQry Count Headhunted by OwnedBy Date Range Criteria]
Qry Count Headhunted Qualified by OwnedBy Date Range
Type: Select
SELECT [SubQry Count Headhunted by OwnedBy Date Range Criteria].OwnedBy, Count([SubQry Count Headhunted by OwnedBy Date Range Criteria].[Entrepreneur ID] FROM [SubQry Count Headhunted by OwnedBy Date Range Criteria] WHERE ((([SubQry Count Headhunted by OwnedBy Date Range Criteria].[Step Number])>=2))
Qry Count Purple Panel Results Date Range
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Date Panel Held])>=[Forms]![Frm Reports Print Export Date Dial
Qry Count Raizcorp Possibles Moved Last Week by Delivery Loc
Type: Select
SELECT [Entrepreneur Company].[Company Delivery Location ID], [Delivery Locations].[Delivery Location], Count([Temp Entrepreneur Steps].[Entrepreneur Company ID]) FROM [Temp Entrepreneur Steps], [Entrepreneur Company], [Delivery Locations]
Qry Count Total Assessments Passed by Scout
Type: Select
SELECT [SubQry Rpt Assessment Panel Passes per Scout].OwnedBy, [SubQry Rpt Assessment Panel Passes per Scout].[Entrepreneurial Assessment Resul, Count([SubQry Rpt Assessment Panel Passes per Scout].[Entrepreneurial Assessment FROM [SubQry Rpt Assessment Panel Passes per Scout]
Qry Count Total Assessments Taken by Scout
Type: Select
SELECT [SubQry Rpt Assessment Panel Passes per Scout].OwnedBy, Count([SubQry Rpt Assessment Panel Passes per Scout].[Entrepreneurial Assessment FROM [SubQry Rpt Assessment Panel Passes per Scout]
Qry Count Total Panels Held by Scout
Type: Select
SELECT [SubQry Rpt Assessment Panel Passes per Scout].OwnedBy, Count([SubQry Rpt Assessment Panel Passes per Scout].[Date Panel Held]) FROM [SubQry Rpt Assessment Panel Passes per Scout]
Qry Count Total Panels Passed by Scout
Type: Select
SELECT [SubQry Rpt Assessment Panel Passes per Scout].OwnedBy, [SubQry Rpt Assessment Panel Passes per Scout].[PP Results], Count([SubQry Rpt Assessment Panel Passes per Scout].[Date Panel Held]) FROM [SubQry Rpt Assessment Panel Passes per Scout]
Qry Count Unallocated Companies by EP Delivery Location
Type: Select
SELECT [Qry Get Division Dist Model and Rec Info by Company].[Delivery Location ID], Count([Qry Get Division Dist Model and Rec Info by Company].[Entrepreneur Compan FROM [Entrepreneur Company], [Qry Get Division Dist Model and Rec Info by Company] WHERE ((([Entrepreneur Company].[Company Status ID])=2 Or ([Entrepreneur Company].[Com
Qry Count Unallocated Companies by Principal Project Recommended
Type: Select
SELECT [Qry Get Division Dist Model and Rec Info by Company].[Recommended Principal Pro, Count([Qry Get Division Dist Model and Rec Info by Company].[Entrepreneur Compan FROM [Qry Get Division Dist Model and Rec Info by Company], [Entrepreneur Company] WHERE ((([Entrepreneur Company].[Company Status ID])=2 Or ([Entrepreneur Company].[Com
Qry Digital Stats Report
Type: Select
-- Unable to parse query definition
Qry Duplicate Entrepreneurs
Type: Select
SELECT [SubQry Duplicate Entrepreneurs Alt].[Entrepreneur ID], [First Name] & \, [SubQry Duplicate Entrepreneurs Alt].[EOI Business Name], [SubQry Duplicate Entrepreneurs Alt].[Email Address], ProcessStatus.[Step Number], ProcessStatus.Status, [SubQry Duplicate Entrepreneurs Alt].[Date Status Changed], [Lead Types].[Lead Type] FROM [Lead Types], [ProcessStatus], [SubQry Duplicate Entrepreneurs Alt]
Qry Entrepreneur Company List Principal Projects
Type: Select
SELECT vwPurpleEntrepreneurCompanyListPrincipalProjects.[Entrepreneur ID], [First Name] & \, vwPurpleEntrepreneurCompanyListPrincipalProjects.[Email Address], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Delivery Location], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Entrepreneur Company ID], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Company Name], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Company Status ID], vwPurpleEntrepreneurCompanyListPrincipalProjects.Status, vwPurpleEntrepreneurCompanyListPrincipalProjects.[Sort Order], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Status Modified By], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Date Status Changed], vwPurpleEntrepreneurCompanyListPrincipalProjects.OwnedBy, vwPurpleEntrepreneurCompanyListPrincipalProjects.Product, vwPurpleEntrepreneurCompanyListPrincipalProjects.Industry, vwPurpleEntrepreneurCompanyListPrincipalProjects.[Recommended Product], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Programme Year], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Contract Start Date] FROM [vwPurpleEntrepreneurCompanyListPrincipalProjects]
Qry Entrepreneur Company List
Type: Select
SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Business Address 1], [Entrepreneur Company].[Business Address 2] FROM [Entrepreneur Company]
Qry Entrepreneur Digital Selection List
Type: Select
SELECT vwPurpleEntrepreneurList.[Entrepreneur ID], vwPurpleEntrepreneurList.[Company Status ID], vwPurpleEntrepreneurList.[Student ID], vwPurpleEntrepreneurList.[Selection Type], [First Name] & \, vwPurpleEntrepreneurList.[Company Name], vwPurpleEntrepreneurList.Step, vwPurpleEntrepreneurList.Status, vwPurpleEntrepreneurList.[Sort Order], vwPurpleEntrepreneurList.[Date Status Changed], vwPurpleEntrepreneurList.[Lead Type], vwPurpleEntrepreneurList.Province, vwPurpleEntrepreneurList.Industry, vwPurpleEntrepreneurList.Division, vwPurpleEntrepreneurList.[Delivery Location], vwPurpleEntrepreneurList.OwnedBy, vwPurpleEntrepreneurList.[Process Status ID], vwPurpleEntrepreneurList.[Date Record Created], vwPurpleEntrepreneurList.[Date Modified], vwPurpleEntrepreneurList.[Last Modified By], [Principal] & \, vwPurpleEntrepreneurList.[Process Date], vwPurpleEntrepreneurList.[Recommended Product], vwPurpleEntrepreneurList.[Email Address] FROM [vwPurpleEntrepreneurList] WHERE (((vwPurpleEntrepreneurList.[Selection Type])=2))
Qry Entrepreneur List Company Commodity
Type: Select
SELECT vwPurpleEntrepreneurListCompanyCommodity.[Entrepreneur ID], vwPurpleEntrepreneurListCompanyCommodity.[Student ID], vwPurpleEntrepreneurListCompanyCommodity.[Company Name], vwPurpleEntrepreneurListCompanyCommodity.Step, [First Name] & \, vwPurpleEntrepreneurListCompanyCommodity.Status, vwPurpleEntrepreneurListCompanyCommodity.[Sort Order], vwPurpleEntrepreneurListCompanyCommodity.[Date Status Changed], vwPurpleEntrepreneurListCompanyCommodity.[Lead Type], vwPurpleEntrepreneurListCompanyCommodity.Province, vwPurpleEntrepreneurListCompanyCommodity.Industry, vwPurpleEntrepreneurListCompanyCommodity.[Delivery Location], vwPurpleEntrepreneurListCompanyCommodity.OwnedBy, vwPurpleEntrepreneurListCompanyCommodity.[Process Status ID], vwPurpleEntrepreneurListCompanyCommodity.[Date Record Created], vwPurpleEntrepreneurListCompanyCommodity.[Date Modified], vwPurpleEntrepreneurListCompanyCommodity.[Last Modified By], [Principal] & \, vwPurpleEntrepreneurListCompanyCommodity.[Recommended Product], vwPurpleEntrepreneurListCompanyCommodity.[Email Address], vwPurpleEntrepreneurListCompanyCommodity.Commodity FROM [vwPurpleEntrepreneurListCompanyCommodity]
Qry Entrepreneur List Current Principal Projects
Type: Select
SELECT vwPurpleEntrepreneurListCurrentPrincipalProjects.[Process Status ID], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Entrepreneur Company ID], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Entrepreneur ID], [First Name] & \, vwPurpleEntrepreneurListCurrentPrincipalProjects.[Company Name], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Company Status ID], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Date Status Changed], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Status Modified By], vwPurpleEntrepreneurListCurrentPrincipalProjects.Status, vwPurpleEntrepreneurListCurrentPrincipalProjects.[Lead Type], vwPurpleEntrepreneurListCurrentPrincipalProjects.Province, vwPurpleEntrepreneurListCurrentPrincipalProjects.Industry, vwPurpleEntrepreneurListCurrentPrincipalProjects.Division, vwPurpleEntrepreneurListCurrentPrincipalProjects.[Delivery Location], vwPurpleEntrepreneurListCurrentPrincipalProjects.OwnedBy, vwPurpleEntrepreneurListCurrentPrincipalProjects.[Date Record Created], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Date Modified], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Last Modified By], [vwPurpleEntrepreneurListCurrentPrincipalProjects].[Principal] & \, vwPurpleEntrepreneurListCurrentPrincipalProjects.[Process Date], IIf([Ring Fencing]=True,\, vwPurpleEntrepreneurListCurrentPrincipalProjects.[Recommended Product], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Email Address], vwPurpleGetCurrentContractInfobyCompany.[Date Contract Signed], vwPurpleGetCurrentContractInfobyCompany.[VA Packs Delivered], vwPurpleGetCurrentContractInfobyCompany.[Contract Start Date] FROM [vwPurpleGetCurrentContractInfobyCompany], [vwPurpleEntrepreneurListCurrentPrincipalProjects]
Qry Entrepreneur List Ignition Dashboard
Type: Select
SELECT vwPurpleEntrepreneurListIgnitionDashboard.[Entrepreneur ID], vwPurpleEntrepreneurListIgnitionDashboard.[Student ID], vwPurpleEntrepreneurListIgnitionDashboard.[Entrepreneur Company ID], vwPurpleEntrepreneurListIgnitionDashboard.[Entrepreneur Company Programme Years , vwPurpleEntrepreneurListIgnitionDashboard.[Entrepreneur Company Principal Projec, vwPurpleEntrepreneurListIgnitionDashboard.[Ignition Date], IIf([Ignition Date]<Date(),\, vwPurpleEntrepreneurListIgnitionDashboard.[Company Name], vwPurpleEntrepreneurListIgnitionDashboard.[Company Status ID], vwPurpleEntrepreneurListIgnitionDashboard.Status, vwPurpleEntrepreneurListIgnitionDashboard.[Date Status Changed], vwPurpleEntrepreneurListIgnitionDashboard.[Status Modified By], vwPurpleEntrepreneurListIgnitionDashboard.Province, vwPurpleEntrepreneurListIgnitionDashboard.Industry, vwPurpleEntrepreneurListIgnitionDashboard.[Delivery Location], vwPurpleEntrepreneurListIgnitionDashboard.OwnedBy, vwPurpleEntrepreneurListIgnitionDashboard.[Process Status ID], vwPurpleEntrepreneurListIgnitionDashboard.[Date Record Created], [Principal] & \, vwPurpleEntrepreneurListIgnitionDashboard.[Process Date], vwPurpleEntrepreneurListIgnitionDashboard.Product, vwPurpleEntrepreneurListIgnitionDashboard.[Programme Year], vwPurpleEntrepreneurListIgnitionDashboard.[Contract Start Date] FROM [vwPurpleEntrepreneurListIgnitionDashboard]
Qry Entrepreneur List Part Sponsorship
Type: Select
SELECT vwPurpleEntrepreneurListPartSponsorship.[Process Status ID], vwPurpleEntrepreneurListPartSponsorship.[Lump Sum Allocation], vwPurpleEntrepreneurListPartSponsorship.[Entrepreneur Company ID], vwPurpleEntrepreneurListPartSponsorship.[Entrepreneur ID], vwPurpleEntrepreneurListPartSponsorship.[Company Status ID], vwPurpleEntrepreneurListPartSponsorship.OwnedBy, vwPurpleEntrepreneurListPartSponsorship.Status, vwPurpleEntrepreneurListPartSponsorship.[Date Status Changed], vwPurpleEntrepreneurListPartSponsorship.[Delivery Location], vwPurpleEntrepreneurListPartSponsorship.[Company Name], [First Name] & \, vwPurpleEntrepreneurListPartSponsorship.Industry, vwPurpleEntrepreneurListPartSponsorship.[Total Programme Amount], vwPurpleEntrepreneurListPartSponsorship.Principal, vwPurpleEntrepreneurListPartSponsorship.[Project Name], vwPurpleEntrepreneurListPartSponsorship.[Recommended Product], vwPurpleEntrepreneurListPartSponsorship.Yr, IIf(IsNull([Total Allocated Amt]),0,[Total Allocated Amt]), [Total Programme Amount]-IIf(IsNull([Total Allocated Amt]),0,[Total Allocated Am, [Principal] & \ FROM [Qry Sum Total Allocated Amt by Company], [vwPurpleEntrepreneurListPartSponsorship]
Qry Entrepreneur List Purple Meeting
Type: Select
SELECT [Principal] & \, [Temp Purple Meeting Status].[Step 2], [Temp Purple Meeting Status].[Step 3], [Temp Purple Meeting Status].[Step 4], [Temp Purple Meeting Status].[Step 5], [Temp Purple Meeting Status].[Step 6], [Temp Purple Meeting Status].[Step 7], [Temp Purple Meeting Status].[Not Allocated (Companies)], [Temp Purple Meeting Status].[Allocated (Companies)], [Temp Purple Meeting Status].[Step 8 (Ready for Allocation)] FROM [Temp Purple Meeting Status], [Principal Projects], [Principals]
Qry Entrepreneur List
Type: Select
SELECT vwPurpleEntrepreneurList.[Entrepreneur ID], vwPurpleEntrepreneurList.[Company Status ID], vwPurpleEntrepreneurList.[Student ID], [First Name] & \, vwPurpleEntrepreneurList.[Company Name], vwPurpleEntrepreneurList.Step, vwPurpleEntrepreneurList.Status, vwPurpleEntrepreneurList.[Sort Order], vwPurpleEntrepreneurList.[Date Status Changed], vwPurpleEntrepreneurList.[Lead Type], vwPurpleEntrepreneurList.Province, vwPurpleEntrepreneurList.Industry, vwPurpleEntrepreneurList.Division, vwPurpleEntrepreneurList.[Delivery Location], vwPurpleEntrepreneurList.OwnedBy, vwPurpleEntrepreneurList.[Process Status ID], vwPurpleEntrepreneurList.[Date Record Created], vwPurpleEntrepreneurList.[Date Modified], vwPurpleEntrepreneurList.[Last Modified By], [Principal] & \, vwPurpleEntrepreneurList.[Process Date], vwPurpleEntrepreneurList.[Recommended Product], vwPurpleEntrepreneurList.[Email Address] FROM [vwPurpleEntrepreneurList]
Qry Entrepreneurs in a Company List
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Entrepreneur Company ID], [First Name] & \ FROM [Entrepreneurs]
Qry Export Blue Eagle Entrepreneurs
Type: Select
SELECT Entrepreneurs.[Blue Eagle Recommendation Date], Entrepreneurs.[Blue Eagle Exported], Entrepreneurs.[First Name], Entrepreneurs.Surname, Entrepreneurs.[Email Address], Entrepreneurs.[Telephone Number], \ FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Blue Eagle Recommendation Date]) Is Not Null) AND ((Entreprene
Qry Export Daily Lead Summary Leads Less Than 48 Hours
Type: Select
SELECT [Lead Types].[Lead Type], Entrepreneurs.[Date Record Created], Entrepreneurs.[Date Status Changed], [Entrepreneur Company].[Company Name], [First Name] & \, Entrepreneurs.[Telephone Number], Entrepreneurs.[Email Address], ProcessStatus.Status, [Delivery Locations].[Delivery Location], Entrepreneurs.OwnedBy FROM [Entrepreneurs], [Lead Types], [ProcessStatus], [Entrepreneur Company], [Delivery Locations] WHERE (((Entrepreneurs.[Date Status Changed])>=[Forms]![Frm Reports Single Date Dialog
Qry Export Daily Lead Summary Leads More Than 48 Hours
Type: Select
SELECT [Lead Types].[Lead Type], Entrepreneurs.[Date Record Created], Entrepreneurs.[Date Status Changed], [Entrepreneur Company].[Company Name], [First Name] & \, Entrepreneurs.[Telephone Number], Entrepreneurs.[Email Address], ProcessStatus.Status, [Delivery Locations].[Delivery Location], Entrepreneurs.OwnedBy FROM [Entrepreneurs], [Lead Types], [ProcessStatus], [Entrepreneur Company], [Delivery Locations] WHERE (((Entrepreneurs.[Date Status Changed])<[Forms]![Frm Reports Single Date Dialog]
Qry Export Entrepreneurs All Lead Types
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], Entrepreneurs.Province, IndustryLookup.Industry, [First Name] & \, [Entrepreneur Company].[Company Name], Entrepreneurs.[Process Date], ProcessStatus.Status, Entrepreneurs.OwnedBy FROM [IndustryLookup], [Entrepreneurs], [Lead Types], [ProcessStatus], [Entrepreneur Company], [TerminationReason], [UnqualifiedReason] WHERE (((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Lead Detail Report Date Di
Qry Export Entrepreneurs by Lead Type
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], Entrepreneurs.Province, IndustryLookup.Industry, [First Name] & \, [Entrepreneur Company].[Company Name], Entrepreneurs.[Process Date], ProcessStatus.Status, Entrepreneurs.OwnedBy FROM [IndustryLookup], [Entrepreneurs], [Lead Types], [ProcessStatus], [Entrepreneur Company], [Temp Lead Type for Lead Report] WHERE (((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Lead Detail Report Date Di
Qry Export Temp Entrepreneur Steps
Type: Select
-- Unable to parse query definition
Qry Get BEE and Tax Clearance Alerts
Type: Select
SELECT vwPurpleGetBEEAndTaxClearanceAlerts.[Entrepreneur ID], vwPurpleGetBEEAndTaxClearanceAlerts.[Process Status ID], vwPurpleGetBEEAndTaxClearanceAlerts.[Company Status ID], vwPurpleGetBEEAndTaxClearanceAlerts.[Date Record Created], vwPurpleGetBEEAndTaxClearanceAlerts.[Delivery Location ID], vwPurpleGetBEEAndTaxClearanceAlerts.[Delivery Location], [First Name] & \, vwPurpleGetBEEAndTaxClearanceAlerts.[Company Name], vwPurpleGetBEEAndTaxClearanceAlerts.[BEE Certificate Expire Date], vwPurpleGetBEEAndTaxClearanceAlerts.[Tax Clearance Expire Date], vwPurpleGetBEEAndTaxClearanceAlerts.OwnedBy, IIf(DateDiff(\, IIf(IsNull([Company Status]),[Process Status],[Company Status]), DateDiff(\, DateDiff(\ FROM [vwPurpleGetBEEAndTaxClearanceAlerts] WHERE (((DateDiff(\"d\",Date(),[BEE Certificate Expire Date]))<=30)) OR (((DateDiff(\"
Qry Get Current Contract Info by Company
Type: Select
SELECT vwPurpleGetCurrentContractInfobyCompany.[Entrepreneur Company ID], vwPurpleGetCurrentContractInfobyCompany.[Division ID], vwPurpleGetCurrentContractInfobyCompany.[Programme Year], vwPurpleGetCurrentContractInfobyCompany.[Principal Project ID], vwPurpleGetCurrentContractInfobyCompany.Principal, [Principal] & \, vwPurpleGetCurrentContractInfobyCompany.[Product ID], vwPurpleGetCurrentContractInfobyCompany.Product, vwPurpleGetCurrentContractInfobyCompany.[Contract Start Date] FROM [Qry Sum Total Allocated Amt by Company], [vwPurpleGetCurrentContractInfobyCompany]
Qry Get Del Loc Raizcorpossibles Part Sponsorship
Type: Select
-- Unable to parse query definition
Qry Get Delivery Locations Allowed by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], [Principal Project Pillar Delivery Location].[Delivery Location] FROM [Principal Project Pillars], [Principal Project Pillar Delivery Location]
Qry Get Delivery Locations Quartz Lead Phase Report
Type: Select
-- Unable to parse query definition
Qry Get Division Dist Model and Rec Info by Company
Type: Select
SELECT Entrepreneurs.[Entrepreneur Company ID], Entrepreneurs.[Process Status ID], Entrepreneurs.[Delivery Location ID], Entrepreneurs.[Division ID], Entrepreneurs.[Distribution Model ID], Entrepreneurs.[Recommended Principal Project ID], Entrepreneurs.[Recommended Product ID], Entrepreneurs.[Pipeline ID] FROM [Entrepreneurs]
Qry Get Division Dist Model Del Loc and Rec Info by Company
Type: Select
SELECT Entrepreneurs.[Entrepreneur Company ID], Entrepreneurs.[Division ID], Entrepreneurs.[Distribution Model ID], Entrepreneurs.[Recommended Principal Project ID], Entrepreneurs.[Recommended Product ID], Entrepreneurs.[Pipeline ID], Entrepreneurs.[Delivery Location ID] FROM [Entrepreneurs]
Qry Get Entrepreneur Info for Projile Merge
Type: Select
SELECT Entrepreneurs.[Entrepreneur Company ID], Entrepreneurs.[Profile Created], Entrepreneurs.[Division ID] FROM [Entrepreneurs]
Qry Get Entrepreneur Recommended Information
Type: Select
SELECT Entrepreneurs.[Entrepreneur Company ID], [Principal] & \, Entrepreneurs.[Recommended BBBEE Pillar], Products.Product, Entrepreneurs.[Division ID], Entrepreneurs.[Distribution Model ID] FROM [Entrepreneurs], [Principal Projects], [Principals], [Products], [Lead Types]
Qry Get Entrepreneur Steps by Delivery Location
Type: Select
SELECT vwPurpleGetEntrepreneurSteps.[Entrepreneur ID], vwPurpleGetEntrepreneurSteps.[Step Number], Max(vwPurpleGetEntrepreneurSteps.[Date Status Changed]) FROM [SubQry Get Entrepreneur Steps Delivery Location Criteria], [vwPurpleGetEntrepreneurSteps]
Qry Get Entrepreneur Steps by Lead Type
Type: Select
SELECT vwPurpleGetEntrepreneurSteps.[Entrepreneur ID], vwPurpleGetEntrepreneurSteps.[Step Number], Max(vwPurpleGetEntrepreneurSteps.[Date Status Changed]) FROM [SubQry Get Entrepreneur Steps Lead Type Criteria], [vwPurpleGetEntrepreneurSteps]
Qry Get Entrepreneur Steps by Owned By
Type: Select
SELECT vwPurpleGetEntrepreneurSteps.[Entrepreneur ID], vwPurpleGetEntrepreneurSteps.[Step Number], Max(vwPurpleGetEntrepreneurSteps.[Date Status Changed]) FROM [SubQry Get Entrepreneur Steps Owned by Criteria], [vwPurpleGetEntrepreneurSteps]
Qry Get Entrepreneur Steps by Recommended Principal Project
Type: Select
SELECT vwPurpleGetEntrepreneurSteps.[Entrepreneur ID], vwPurpleGetEntrepreneurSteps.[Step Number], Max(vwPurpleGetEntrepreneurSteps.[Date Status Changed]) FROM [SubQry Get Entrepreneur Steps Recommended Principal Project Crit], [vwPurpleGetEntrepreneurSteps]
Qry Get Entrepreneur Steps Date Range
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Pipeline ID], ProcessStatus.[Step Number], Max([Entrepreneur Status History].[Date Status Changed]) FROM [SubQry Get Entrepreneur Steps Date Range Criteria], [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus]
Qry Get Entrepreneur Steps For Summary
Type: Select
SELECT [SubQry Get Entrepreneur Steps For Summary Criteria].[Entrepreneur ID], [SubQry Get Entrepreneur Steps For Summary Criteria].[Date Record Created], [SubQry Get Entrepreneur Steps For Summary Criteria].[Step Number], Max([SubQry Get Entrepreneur Steps For Summary Criteria].[Date Status Changed]) FROM [SubQry Get Entrepreneur Steps For Summary Criteria]
Qry Get Entrepreneurs Modified Pipeline 1 Prin Proj Date Range
Type: Select
SELECT [SubQry Get EPs Modified Pipeline 1 Prin Proj Date Range Crit].[Pipeline ID], Entrepreneurs.[Entrepreneur ID], [SubQry Get EPs Modified Pipeline 1 Prin Proj Date Range Crit].[First Day Step 8, Entrepreneurs.[Date Record Created], ProcessStatus.[Step Number] FROM [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus], [SubQry Get EPs Modified Pipeline 1 Prin Proj Date Range Crit]
Qry Get Entrepreneurs Modified Pipeline Date Range
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], [SubQry Get Entrepreneurs Modified Pipeline Date Range Crit].[Pipeline ID], ProcessStatus.[Step Number], [SubQry Get Entrepreneurs Modified Pipeline Date Range Crit].[First Day Step 8] FROM [SubQry Get Entrepreneurs Modified Pipeline Date Range Crit], [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus]
Qry Get Entrepreneurs Modified Pipeline Last 6 Months
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], [SubQry Get Entrepreneurs Modified Pipeline Last 6 Months Crit].[Pipeline ID], Entrepreneurs.[Date Record Created], ProcessStatus.[Step Number], [SubQry Get Entrepreneurs Modified Pipeline Last 6 Months Crit].[First Day Step FROM [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus], [SubQry Get Entrepreneurs Modified Pipeline Last 6 Months Crit]
Qry Get Entrepreneurs Reactivated for Summary
Type: Select
SELECT [SubQry Get Entrepreneur Steps For Summary Criteria].[Entrepreneur ID], [SubQry Get Entrepreneur Steps For Summary Criteria].[Process Status ID] FROM [SubQry Get Entrepreneur Steps For Summary Criteria]
Qry Get Entrepreneurs Steps Modified by Owned By Date Range
Type: Select
SELECT [SubQry Get Entrepreneurs Mod OwnedBy Date Range Crit].[Entrepreneur ID], Entrepreneurs.[Date Record Created], Entrepreneurs.OwnedBy, ProcessStatus.[Step Number], Max([Entrepreneur Status History].[Date Status Changed]) FROM [SubQry Get Entrepreneurs Mod OwnedBy Date Range Crit], [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus]
Qry Get Last Note by Entrepreneur
Type: Select
SELECT [Entrepreneur Notes].[Entrepreneur ID], [Entrepreneur Notes].[Note Date], [Entrepreneur Notes].Notes FROM [Qry Get Last Note Date by Entrepreneur], [Entrepreneur Notes]
Qry Get Last Note Date by Entrepreneur
Type: Select
SELECT [Entrepreneur Notes].[Entrepreneur ID], Max([Entrepreneur Notes].[Note Date]), Max([Entrepreneur Notes].[Entrepreneur Note ID]) FROM [Entrepreneur Notes]
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 Info by Company
Type: Select
SELECT [Qry Get Last Programme Year ID by Company].[Entrepreneur Company ID], [Entrepreneur Company Programme Years].[Programme Year], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Qry Get Last Programme Year ID by Company], [Entrepreneur Company Programme Years], [Products], [CompanyProgrammeYearStatus], [NonGraduateReason]
Qry Get Lead Types for Passed Panel Entrepreneurs
Type: Select
SELECT Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Source], Entrepreneurs.[PP Results] FROM [Entrepreneurs], [Lead Types], [ProcessStatus] WHERE (((Entrepreneurs.[Date Panel Held])>=[Forms]![Frm Marketing Lead Report Date Dia
Qry Get Owned By Panels Passed by Scout
Type: Select
-- Unable to parse query definition
Qry Get OwnedBy for Selection Team Target Report
Type: Select
SELECT [Temp Entrepreneur Steps].OwnedBy FROM [Temp Entrepreneur Steps]
Qry Get Pipeline Steps Between 1 and 8
Type: Select
SELECT Pipelines.[Pipeline ID], Pipelines.Pipeline, ProcessStatus.[Step Number] FROM [Pipelines], [Pipelines Detail], [ProcessStatus]
Qry Get Raizcorp Possibles Moved Last Week
Type: Select
SELECT [SubQry Get Raizcorp Possibles Position].[Entrepreneur Company ID], [Entrepreneur Company Status History].[Entrepreneur Company Status ID], [Entrepreneur Company Status History].[Company Status ID], [Entrepreneur Company Status History].[Date Status Changed], CompanyStatus.Status FROM [CompanyStatus], [Entrepreneur Company Status History], [SubQry Get Raizcorp Possibles Position] WHERE ((([Entrepreneur Company Status History].[Entrepreneur Company Status ID])>=[Sub
Qry Get Sheet Names for Conpany Profiles
Type: Select
SELECT [Qry Count Entrepreneurs by Company for Projile].[Number of Entrepreneurs] FROM [Qry Count Entrepreneurs by Company for Projile]
Qry Lead Type List
Type: Select
SELECT [Lead Types].[Lead Type ID], [Lead Types].[Lead Type], [Lead Types].[Lead Source], [Principal] & \, [Lead Types].[Lead Format], IndustryLookup.Industry, [Lead Types].[Import Template], [Lead Types].Status FROM [Lead Types], [IndustryLookup], [Principal Projects], [Principals]
Qry Notifications Sent by Entrpreneur
Type: Select
SELECT [Entrepreneur Notifications Sent].[Notification Date], [Entrepreneur Notifications Sent].[Notification Type], [Entrepreneur Notifications Sent].[Entrepreneur ID] FROM [Entrepreneur Notifications Sent] WHERE ((([Entrepreneur Notifications Sent].[Entrepreneur ID])=[Forms]![Frm Entrepreneu
Qry Pipeline Detail List
Type: Select
SELECT [Pipelines Detail].[Pipeline ID], [Pipelines Detail].[Pipeline Detail ID], ProcessStatus.[Step Number], ProcessStatus.Status, ProcessStatus.[Sort Order], ProcessStatus.Active FROM [Pipelines Detail], [ProcessStatus]
Qry Possible Date Created
Type: Select
SELECT Entrepreneurs.[Date Record Created] FROM [Entrepreneurs]
Qry Principal List
Type: Select
SELECT Principals.[Principal ID], Principals.Principal, Principals.[Principal Address 1], Principals.[Principal Address 2] FROM [Principals]
Qry Process Status List Digital Pipelines
Type: Select
SELECT Pipelines.[Selection Type], ProcessStatus.[Process Status ID], ProcessStatus.[Step Number], ProcessStatus.Status, ProcessStatus.[Sort Order], ProcessStatus.Active FROM [Pipelines], [Pipelines Detail], [ProcessStatus] WHERE (((Pipelines.[Selection Type])=2))
Qry Process Status NOT in Pipeline List
Type: Select
SELECT [SubQry Process Status NOT in Pipeline List].[Process Status ID], ProcessStatus.[Process Status ID], ProcessStatus.[Step Number], ProcessStatus.Status, ProcessStatus.[Sort Order], ProcessStatus.Active FROM [ProcessStatus], [SubQry Process Status NOT in Pipeline List] WHERE ((([SubQry Process Status NOT in Pipeline List].[Process Status ID]) Is Null) AN
Qry Product Distribution Model List
Type: Select
SELECT Products.[Product ID], [Product Distribution Models].[Product Distribution Model ID], Products.Product, [Distribution Models].[Distribution Model] FROM [Products], [Distribution Models], [Product Distribution Models]
Qry Product Division List
Type: Select
SELECT Products.[Product ID], [Product Divisions].[Product Division ID], Products.Product, Divisions.Division FROM [Products], [Product Divisions], [Divisions]
Qry Product List
Type: Select
SELECT Products.[Product ID], Products.Product, Pipelines.Pipeline, Products.[Pipeline ID] FROM [Products], [Pipelines]
Qry Report Active Companies Email
Type: Select
SELECT [Entrepreneur Company].[Company Status ID], Entrepreneurs.[Process Status ID], Entrepreneurs.[Distribution Model ID], [Distribution Models].[Distribution Model], Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Company Name], [First Name] & \, Entrepreneurs.[Email Address] FROM [Entrepreneurs], [Entrepreneur Company], [Distribution Models] WHERE ((([Entrepreneur Company].[Company Status ID])=3) AND ((Entrepreneurs.[Process S
Qry Report Allocation Export Graduated Companies
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Entrepreneur Company ID], Entrepreneurs.[Division ID], [Entrepreneur Company].[Company Status ID], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], CompanyProgrammeYearStatus.[Programme Year Status], [Entrepreneur Company Programme Years].[Date Status Changed], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [IndustryLookup], [Principal Projects], [Principals], [Qry Sum Total Spend by Principal Project], [Entrepreneurs], [Products], [Principal Project Pillars], [Entrepreneur Company], [Delivery Locations], [SubQry Get Last Programme Year for Exited Companies], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [CompanyStatus], [CompanyProgrammeYearStatus], [Qry Sum Total Allocated Amt by Company] WHERE (((Entrepreneurs.[Division ID])<>3) AND (([Entrepreneur Company Programme Years]
Qry Report Allocation Export Non Graduate Companies
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Entrepreneur Company ID], Entrepreneurs.[Division ID], [Entrepreneur Company].[Company Status ID], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], CompanyProgrammeYearStatus.[Programme Year Status], [Entrepreneur Company Programme Years].[Date Status Changed], NonGraduateReason.[Non Graduate Reason], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [IndustryLookup], [Principal Projects], [Principals], [Qry Sum Total Spend by Principal Project], [Entrepreneurs], [Products], [Principal Project Pillars], [Entrepreneur Company], [Delivery Locations], [SubQry Get Last Programme Year for Exited Companies], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [CompanyStatus], [CompanyProgrammeYearStatus], [NonGraduateReason], [Qry Sum Total Allocated Amt by Company] WHERE (((Entrepreneurs.[Division ID])<>3) AND (([Entrepreneur Company Programme Years]
Qry Report Allocation Export On Programme Companies
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Entrepreneur Company ID], Entrepreneurs.[Division ID], [Entrepreneur Company].[Company Status ID], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], CompanyProgrammeYearStatus.[Programme Year Status], [Entrepreneur Company Programme Years].[Date Status Changed], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [IndustryLookup], [Principal Projects], [Principals], [Qry Sum Total Spend by Principal Project], [Entrepreneurs], [Products], [Principal Project Pillars], [Entrepreneur Company], [Delivery Locations], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [CompanyStatus], [CompanyProgrammeYearStatus], [Qry Sum Total Allocated Amt by Company] WHERE (((Entrepreneurs.[Division ID])<>3) AND (([Entrepreneur Company Programme Years]
Qry Report Arize First Meeting
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], [First Name] & \, [Entrepreneur Company].[Company Name], [Entrepreneur Arize First Meeting].[Interviewed By], [Entrepreneur Arize First Meeting].[Date Interviewed], Products.Product, [Entrepreneur Arize First Meeting].[Part I Q1 Share a Bit], [Entrepreneur Arize First Meeting].[Part I Q2 Belief System], [Entrepreneur Arize First Meeting].[Part I Q3 Vision], [Entrepreneur Arize First Meeting].[Part I Q4 Working Well], [Entrepreneur Arize First Meeting].[Part I Q5 Greatest Stress], [Entrepreneur Arize First Meeting].[Part I Q6 How Can Help], IIf([Part I Q7 Other Incubator]=True,\, [Entrepreneur Arize First Meeting].[Part I Q7 Other Incubator Text], IIf([Part I Q8 Time Committment]=True,\, [Entrepreneur Arize First Meeting].[Part I Q8 Time Committment Text], IIf([Part I Q9A Attending Sessions]=True,\, [Entrepreneur Arize First Meeting].[Part I Q9A Attending Sessions Text], IIf([Part I Q9B Submitting Assignments]=True,\, [Entrepreneur Arize First Meeting].[Part I Q9B Submitting Assignments Text], IIf([Part I Q9C Paying Fee]=True,\, [Entrepreneur Arize First Meeting].[Part I Q9C Paying Fee Text], [Entrepreneur Arize First Meeting].[Part I Q10 Willing to Give Up], [Entrepreneur Arize First Meeting].[Part I Q11 Cover Business], [Entrepreneur Arize First Meeting].[OK to Continue], IIf([OK to Continue]=True,\, [Entrepreneur Arize First Meeting].[Part II Q1 Biggest Purchases 1], [Entrepreneur Arize First Meeting].[Part II Q1 Biggest Purchases 2], [Entrepreneur Arize First Meeting].[Part II Q1 Biggest Purchases 3], [Entrepreneur Arize First Meeting].[Part II Q2 Biggest Invoices 1], [Entrepreneur Arize First Meeting].[Part II Q2 Biggest Invoices 2], [Entrepreneur Arize First Meeting].[Part II Q2 Biggest Invoices 3], [Entrepreneur Arize First Meeting].[Part II Q3 Greatest Challenge], [Entrepreneur Arize First Meeting].[Part II Q4 Sustain Business], [Entrepreneur Arize First Meeting].[Part II Q5 Who Do You Go To], [Entrepreneur Arize First Meeting].[Part II Q6 Current Weaknesses], [Entrepreneur Arize First Meeting].[Part II Q7 Overcome Weaknesses], [Entrepreneur Arize First Meeting].[Part II Q8 Current Strengths], [Entrepreneur Arize First Meeting].[Part II Q9 Achieve Success], [Entrepreneur Arize First Meeting].[Part II Q10 Learned From Success], [Entrepreneur Arize First Meeting].[Part III Q1 Type of Language], [Entrepreneur Arize First Meeting].[Part III Q1 Type of Language Text], [Entrepreneur Arize First Meeting].[Part III Q2 Desire New Clients], [Entrepreneur Arize First Meeting].[Part III Q2 Desire New Clients Text], [Entrepreneur Arize First Meeting].[Part III Q3 Level of Certainty], [Entrepreneur Arize First Meeting].[Part III Q3 Level of Certainty Text], [Entrepreneur Arize First Meeting].[Part III Q4 Level of Blame], [Entrepreneur Arize First Meeting].[Part III Q4 Level of Blame Text], [Entrepreneur Arize First Meeting].[Part III Q5 Raizcorp as Saviour], [Entrepreneur Arize First Meeting].[Part III Q5 Raizcorp as Saviour Text], [Entrepreneur Arize First Meeting].[Part III Q6 Compelling Vision], [Entrepreneur Arize First Meeting].[Part III Q6 Compelling Vision Text], [Entrepreneur Arize First Meeting].[Part IV Scouts Recommendation], IIf([Part IV Scouts Recommendation]=True,\, [Entrepreneur Arize First Meeting].[Part IV Scouts Recommendation Text], [Entrepreneur Arize First Meeting].[Arize First Meeting Notes], [Entrepreneur Arize First Meeting].[Part FC FF Q1A Do To Build Business Strategy, [Entrepreneur Arize First Meeting].[Part FC FF Q1B How Do You Document Business , [Entrepreneur Arize First Meeting].[Part FC FF Q2A Prepared to Spend Time On Bus, [Entrepreneur Arize First Meeting].[Part FC FF Q2B How Do We Know You Will], IIf([Part FC FF Q3A Work Life Balance]=1,\, [Entrepreneur Arize First Meeting].[Part FC FF Q3B Work Life Balance Reason], IIf([Part FC FF Q4A Good Bad Managers]=1,\, [Entrepreneur Arize First Meeting].[Part FC FF Q4B Good Bad Managers Reason], [Entrepreneur Arize First Meeting].[Part FC FF Q5 Tell About A Process], [Entrepreneur Arize First Meeting].[Part FC FF Q6 Someone Not Performing], [Entrepreneur Arize First Meeting].[Part FC FF Q7 Clients Only Want You], [Entrepreneur Arize First Meeting].[Part FC FF Q8 Do Something Properly] FROM [Entrepreneurs], [Entrepreneur Company], [Products], [Entrepreneur Arize First Meeting] WHERE ((([Entrepreneur Arize First Meeting].[Interviewed By]) Is Not Null))
Qry Report Average Days Per Step
Type: Select
SELECT [SubQry Rpt Average Days Per Step Get DL and Owner].[Delivery Location ID], [SubQry Rpt Average Days Per Step Get DL and Owner].[Delivery Location], [SubQry Rpt Average Days Per Step Get DL and Owner].OwnedBy, IIf([EPs Step 1-2]=0,0,[Days Step 1-2]/[EPs Step 1-2]), IIf([EPs Step 2-3]=0,0,[Days Step 2-3]/[EPs Step 2-3]), IIf([EPs Step 3-4]=0,0,[Days Step 3-4]/[EPs Step 3-4]), IIf([EPs Step 4-5]=0,0,[Days Step 4-5]/[EPs Step 4-5]), IIf([EPs Step 5-6]=0,0,[Days Step 5-6]/[EPs Step 5-6]), IIf([EPs Step 6-7]=0,0,[Days Step 6-7]/[EPs Step 6-7]), IIf([EPs Step 7-8]=0,0,[Days Step 7-8]/[EPs Step 7-8]) FROM [SubQry Rpt Average Days Per Step Get DL and Owner], [SubQry Rpt Average Days Per Step Sum Days], [SubQry Rpt Average Days Per Step Count EPs]
Qry Report Average Time Through Pipeline by Distribution Model
Type: Select
SELECT [SubQry Rpt Average Time Through Pipeline Criteria].[Distribution Model], [SubQry Rpt Average Time Through Pipeline Criteria].Pipeline, DateSerial([TheYear],[TheMonth],1), [Month Name] & \, Count([SubQry Rpt Average Time Through Pipeline Criteria].[Entrepreneur ID]), Sum([SubQry Rpt Average Time Through Pipeline Criteria].[Pipeline Days]) FROM [SubQry Rpt Average Time Through Pipeline Criteria], [MonthLkUp]
Qry Report Avg Time Through Pipeline by Delivery Loc
Type: Select
SELECT [SubQry Rpt Average Time Through Pipeline by Delivery Location].Pipeline, [SubQry Rpt Average Time Through Pipeline by Delivery Location].[Distribution Mo, [SubQry Rpt Average Time Through Pipeline by Delivery Location].[Delivery Locati, [SubQry Rpt Average Time Through Pipeline by Delivery Location].[Number Entrepre, [SubQry Rpt Average Time Through Pipeline by Delivery Location].[Pipeline Days] FROM [SubQry Rpt Average Time Through Pipeline by Delivery Location]
Qry Report Avg Time Through Pipeline Trend by Delivery Location
Type: Select
-- Unable to parse query definition
Qry Report Blank Owned By
Type: Select
SELECT [First Name] & \, [Entrepreneur Company].[Company Name], Entrepreneurs.[Date Record Created], ProcessStatus.[Step Number], ProcessStatus.Status, Entrepreneurs.[Date Status Changed], [Lead Types].[Lead Type], ProcessStatus.[Step Number], Entrepreneurs.OwnedBy, Entrepreneurs.[Date Modified] FROM [Entrepreneurs], [ProcessStatus], [Lead Types], [Products], [Entrepreneur Company] WHERE (((ProcessStatus.[Step Number])>=2 And (ProcessStatus.[Step Number])<=8) AND ((E
Qry Report Blue Heart Email Not Sent
Type: Select
SELECT Entrepreneurs.[Process Status ID], ProcessStatus.Status, ProcessStatus.[Step Number], Entrepreneurs.[Date Status Changed], Entrepreneurs.[Date Blue Heart Email Sent], Entrepreneurs.[Email Address], Entrepreneurs.[First Name], Entrepreneurs.Surname, [DatabaseUsers].[First Name] & \, Entrepreneurs.OwnedBy FROM [Entrepreneurs], [ProcessStatus], [DatabaseUsers] WHERE (((ProcessStatus.[Step Number])=3) AND ((Entrepreneurs.[Date Blue Heart Email Se
Qry Report Company Profile Merge Data
Type: Select
SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Qry Count Entrepreneurs by Company for Projile].[Number of Entrepreneurs], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Brief Description of Business], IndustryLookup.Industry, [Entrepreneur Company].[Average Monthly Turnover], [Entrepreneur Company].[BEE Level], [Entrepreneur Company].[Percentage Black Owned], [Entrepreneur Company].[Percentage Women Black Owned] FROM [Entrepreneur Company], [Qry Count Entrepreneurs by Company for Projile], [IndustryLookup], [Qry Get Entrepreneur Info for Projile Merge] WHERE ((([Entrepreneur Company].[Company Status ID])=1 Or ([Entrepreneur Company].[Com
Qry Report Contract End Date Expire
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Process Status ID], [Entrepreneur Company].[Company Status ID], Entrepreneurs.[Date Record Created], Entrepreneurs.[Delivery Location ID], [Delivery Locations].[Delivery Location], [First Name] & \, [Entrepreneur Company].[Company Name] FROM [Entrepreneurs], [ProcessStatus], [Entrepreneur Company], [Delivery Locations], [CompanyStatus], [Qry Get Last Programme Year ID by Company], [Entrepreneur Company Programme Years] WHERE (((Entrepreneurs.[Process Status ID])=91) AND (([Entrepreneur Company].[Company
Qry Report Contract not Printed or VA Packs not Delivered
Type: Select
SELECT vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Entrepreneur ID], [Principal] & \, vwPurpleReportContractnotPrintedorVAPacksnotDelivered.OwnedBy, vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Process Status ID], [First Name] & \, vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Company Name], vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Company Status ID], vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[Date Contract Signed], vwPurpleReportContractnotPrintedorVAPacksnotDelivered.[VA Packs Delivered] FROM [vwPurpleReportContractnotPrintedorVAPacksnotDelivered]
Qry Report Current Pipeline EP Detail by Principal Project
Type: Select
SELECT [Lead Types].[Lead Source], IIf(IsNull([CompanyStatus].[Sort Order]),[ProcessStatus].[Sort Order],[CompanySt, Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Entrepreneur Company ID], [First Name] & \, [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Brief Description of Business], IIf(IsNull([CompanyStatus].[Status]),[ProgressCategory].[Progress Category],[Com, IIf(IsNull([Entrepreneur Company Programme Years].[Product ID]),IIf(IsNull([Entr, [Delivery Locations].[Delivery Location], IndustryLookup.Industry, Entrepreneurs.[Process Status ID], IIf(IsNull([Principal Project Pillars].[Principal Project ID]),[Recommended Prin FROM [Entrepreneurs], [ProcessStatus], [ProgressCategory], [Lead Types], [Products], [Entrepreneur Company], [IndustryLookup], [Delivery Locations], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [CompanyStatus], [Principal Project Pillars], [Products] WHERE (((Entrepreneurs.[Process Status ID])<>41 And (Entrepreneurs.[Process Status ID]
Qry Report Days in Pipeline Detail
Type: Select
-- Unable to parse query definition
Qry Report Detailed Movement by Date Range
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], [Lead Types].[Lead Type], [First Name] & \, [Entrepreneur Company].[Company Name], Entrepreneurs.[Telephone Number], Entrepreneurs.OwnedBy, Entrepreneurs.Notes FROM [Entrepreneurs], [Lead Types], [SubQry Rpt Detailed Movement Date Range], [Entrepreneur Company]
Qry Report Detailed Movement by Owned By
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], [Lead Types].[Lead Type], [First Name] & \, [Entrepreneur Company].[Company Name], Entrepreneurs.[Telephone Number], Entrepreneurs.OwnedBy, Entrepreneurs.Notes FROM [Entrepreneurs], [Lead Types], [SubQry Rpt Detailed Movement Owned By], [Entrepreneur Company]
Qry Report Detailed Movement by Principal Project
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], IIf(IsNull([Principal Project Pillars].[Principal Project ID]),[Recommended Prin, Entrepreneurs.[Date Record Created], [Lead Types].[Lead Type], [First Name] & \, [Entrepreneur Company].[Company Name], Entrepreneurs.OwnedBy FROM [Entrepreneurs], [Lead Types], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars] WHERE (((IIf(IsNull([Principal Project Pillars].[Principal Project ID]),[Recommended P
Qry Report Detailed Movement by Recommended Principal Project
Type: Select
SELECT Entrepreneurs.[Recommended Principal Project ID], Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], [Lead Types].[Lead Type], [First Name] & \, [Entrepreneur Company].[Company Name], Entrepreneurs.[Telephone Number], Entrepreneurs.OwnedBy, Entrepreneurs.Notes FROM [Entrepreneurs], [Lead Types], [Entrepreneur Company], [SubQry Rpt Detailed Movement Date Range] WHERE (((Entrepreneurs.[Recommended Principal Project ID])=[Forms]![Frm Detailed Movem
Qry Report Detailed Movement Pipeline by Date Range
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], [Lead Types].[Lead Type], [First Name] & \, [Entrepreneur Company].[Company Name], Entrepreneurs.[Telephone Number], Entrepreneurs.OwnedBy, Entrepreneurs.Notes FROM [Entrepreneurs], [Lead Types], [Entrepreneur Company], [SubQry Rpt Detailed Movement Pipeline Date Range]
Qry Report Entrepreneur List Principal Projects
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], [First Name] & \, [Entrepreneur Company].[Company Status ID], [Entrepreneur Company].[Company Name], Entrepreneurs.[Email Address], ProcessStatus.[Step Number], ProcessStatus.Status, Entrepreneurs.[Date Status Changed], [Lead Types].[Lead Type], Entrepreneurs.Province, Products.Product, [Principals].[Principal] & \, IndustryLookup.Industry, Entrepreneurs.OwnedBy, Entrepreneurs.[Process Status ID], Entrepreneurs.[Date Record Created], [Delivery Locations].[Delivery Location], [Principals_1].[Principal] & \, [Entrepreneur Company Programme Years].[Contract Start Date] FROM [IndustryLookup], [Entrepreneurs], [ProcessStatus], [Lead Types], [Products], [Entrepreneur Company], [Principals], [Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals], [Delivery Locations], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects]
Qry Report Entrepreneur List
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Company Status ID], [First Name] & \, [Entrepreneur Company].[Company Name], Entrepreneurs.[Email Address], ProcessStatus.[Step Number], ProcessStatus.Status, Entrepreneurs.[Date Status Changed], [Lead Types].[Lead Type], Entrepreneurs.Province, Products.Product, [Principal] & \, IndustryLookup.Industry, Entrepreneurs.OwnedBy, Entrepreneurs.[Process Status ID], Entrepreneurs.[Date Record Created], [Delivery Locations].[Delivery Location] FROM [IndustryLookup], [Entrepreneurs], [ProcessStatus], [Lead Types], [Products], [Entrepreneur Company], [Principals], [Principal Projects], [Delivery Locations]
Qry Report Entrepreneur Summary by Distribution Model
Type: Select
SELECT vwPurpleReportEntrepreneurSummary.[Distribution Model ID], vwPurpleReportEntrepreneurSummary.[The Product], vwPurpleReportEntrepreneurSummary.[Delivery Location], vwPurpleReportEntrepreneurSummary.[Process Step], vwPurpleReportEntrepreneurSummary.[Step Number], Round(Sum([Weighted EP]),2), Count(vwPurpleReportEntrepreneurSummary.[Entrepreneur ID]) FROM [vwPurpleReportEntrepreneurSummary]
Qry Report Entrepreneur Summary by Principal Project
Type: Select
SELECT vwPurpleReportEntrepreneurSummary.[The Principal Project ID], vwPurpleReportEntrepreneurSummary.[The Product], vwPurpleReportEntrepreneurSummary.[Distribution Model], vwPurpleReportEntrepreneurSummary.[Delivery Location], vwPurpleReportEntrepreneurSummary.[Process Step], vwPurpleReportEntrepreneurSummary.[Step Number], Round(Sum([Weighted EP]),2), Count(vwPurpleReportEntrepreneurSummary.[Entrepreneur ID]) FROM [vwPurpleReportEntrepreneurSummary]
Qry Report Entrepreneurial Profiles
Type: Select
SELECT Entrepreneurs.[Process Status ID], [First Name] & \, CompanyStatus.Status, Entrepreneurs.[Date Panel Held], [Principal] & \, [Entrepreneur Profile Presented To].[Solutions Architect], [Entrepreneur Profile Presented To].[Date Presented], [Entrepreneur Profile Presented To].[Result Date], [Entrepreneur Profile Presented To].Result FROM [Entrepreneurs], [Entrepreneur Profile Presented To], [Principal Projects], [Principals], [SubQry Rpt Entrepreneurial Profiles], [Entrepreneur Company], [CompanyStatus] WHERE (((Entrepreneurs.[Process Status ID])=91))
Qry Report Entrepreneurs by Lead Type
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], [Lead Types].Status, Entrepreneurs.[Lead Type ID], IndustryLookup.Industry, [Lead Types].[Lead Type], Entrepreneurs.Province, [First Name] & \, [Entrepreneur Company].[Company Name], \, Entrepreneurs.[Process Date], ProcessStatus.Status, Entrepreneurs.Notes, IIf([Entrepreneurs].[Process Status ID]=41,[Termination Reason],IIf([Entrepreneu, Entrepreneurs.OwnedBy, [Lead Types].[Principal Project ID] FROM [IndustryLookup], [Entrepreneurs], [Lead Types], [ProcessStatus], [Entrepreneur Company], [TerminationReason], [UnqualifiedReason] WHERE (((Entrepreneurs.[Date Record Created])>=Forms![Frm Lead Detail Report Date Dial
Qry Report Entrepreneurs Invoice Requested
Type: Select
SELECT Entrepreneurs.[Process Status ID], [First Name] & \, [Entrepreneur Company].[Company Name], Products.Product, [Delivery Locations].[Delivery Location], Entrepreneurs.OwnedBy, Entrepreneurs.[Date Status Changed] FROM [Entrepreneurs], [Products], [Entrepreneur Company], [Delivery Locations] WHERE (((Entrepreneurs.[Process Status ID])=66))
Qry Report Entrepreneurs Modified by Date Range
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], [First Name] & \, IndustryLookup.Industry, [Lead Types].[Lead Type], Entrepreneurs.Province, [Entrepreneur Company].[Company Name], \, Entrepreneurs.[Process Date], ProcessStatus.Status, IIf([Entrepreneurs].[Process Status ID]=41,[Termination Reason],IIf([Entrepreneu, Entrepreneurs.OwnedBy, [Lead Types].[Principal Project ID] FROM [IndustryLookup], [Entrepreneurs], [Lead Types], [ProcessStatus], [Entrepreneur Edit History], [Entrepreneur Company], [TerminationReason], [UnqualifiedReason] WHERE ((([Entrepreneur Edit History].[Date Modified])>=[Forms]![Frm Reports Date Dialo
Qry Report EOI Entrepreneur
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Entrepreneur Company ID], Divisions.Division, [First Name] & \, CountryLookup.Country, Entrepreneurs.[SA Citizen], Entrepreneurs.Province, Entrepreneurs.[Identity Number], IIf([SAID]=True,\, Entrepreneurs.[Date of Birth], Int(DateDiff(\, Entrepreneurs.[EOI Citizendship Country], Entrepreneurs.[EOI Ownership Structure], Entrepreneurs.Gender, Entrepreneurs.Race, Entrepreneurs.Location, Entrepreneurs.[Telephone Number], Entrepreneurs.[Second Telephone Number], Entrepreneurs.[Email Address], Entrepreneurs.[Alternative Email Address], Entrepreneurs.[Date Record Created], Entrepreneurs.[Full Time], Entrepreneurs.[Shareholding Percentage], Entrepreneurs.[Style Questionnaire Score], Entrepreneurs.[Style Questionnaire Results], Entrepreneurs.[Personal Audit Score], Entrepreneurs.[Personal Audit Results], Entrepreneurs.[Urgency Result], Entrepreneurs.[Financial Literacy Result], IIf([Entrepreneurial Assessment Results]=1,\, Entrepreneurs.[EA Date], Entrepreneurs.[EA Marker], IIf([EA Retake Results]=1,\, Entrepreneurs.[EA Retake Date], Entrepreneurs.[EA Retake Marker], IIf([PP Results]=1,\, Entrepreneurs.[Purple Panel Score], Entrepreneurs.[Date Panel Held] FROM [Entrepreneurs], [Divisions], [CountryLookup]
Qry Report Headhunting by Owned By
Type: Select
SELECT [SubQry Rpt Headhunting Count Total by Owned By].[Headhunted By], [SubQry Rpt Headhunting Count Total by Owned By].[Total Headhunted], IIf(IsNull([Total Qualified]),0,[Total Qualified]), [Tot Qualified]/[Total Headhunted] FROM [SubQry Rpt Headhunting Count Total by Owned By], [SubQry Rpt Headhunting Count Qualified by Owned By]
Qry Report Lead Daily Breakdown
Type: Select
SELECT [SubQry Rpt Lead Daily Breakdown Count Total Leads].[Date Record Created], [SubQry Rpt Lead Daily Breakdown Count Total Leads].[Lead Type], [SubQry Rpt Lead Daily Breakdown Count Total Leads].[Total Leads Generated], IIf(IsNull([Qualified Leads]),0,[Qualified Leads]), IIf(IsNull([Passed Panel Leads]),0,[Passed Panel Leads]) FROM [SubQry Rpt Lead Daily Breakdown Count Passed Panel Leads], [SubQry Rpt Lead Daily Breakdown Count Qualified Leads], [SubQry Rpt Lead Daily Breakdown Count Total Leads]
Qry Report Lead Type to Principal Allocation
Type: Select
SELECT [SubQry Rpt Lead Type to Principal Allocation Criteria].[Lead Type Principal Pro, [SubQry Rpt Lead Type to Principal Allocation Criteria].[Lead Type], [SubQry Rpt Lead Type to Principal Allocation Criteria].[Allocated Same as Lead , Count([SubQry Rpt Lead Type to Principal Allocation Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Lead Type to Principal Allocation Criteria]
Qry Report Marketing EOI to Passed Panel
Type: Select
SELECT [Temp Lead Type for Lead Report].[Lead Type ID], [Lead Types].[Lead Type], [SubQry Rpt Marketing EOI to Passed Panel Count EOI].[Number of EOI], [SubQry Rpt Marketing EOI to Passed Panel Count Qualified].[Number Qualified], [SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel].[Number Passed Pan, [Number Passed Panel]/[Number Qualified] FROM [Temp Lead Type for Lead Report], [Lead Types], [SubQry Rpt Marketing EOI to Passed Panel Count EOI], [SubQry Rpt Marketing EOI to Passed Panel Count Qualified], [SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel]
Qry Report Marketing Leads by Date
Type: Select
SELECT [SubQry Rpt Count Total Leads Generated by Date].[Date Record Created], [SubQry Rpt Count Total Leads Generated by Date].[Total Leads Generated], IIf(IsNull([Qualified Leads]),0,[Qualified Leads]) FROM [SubQry Rpt Count Total Leads Generated by Date], [SubQry Rpt Count Qualified Leads by Date]
Qry Report Marketing Leads Version Two
Type: Select
SELECT [SubQry Rpt Count Total Leads Generated].[Lead Type], [SubQry Rpt Count Total Leads Generated].[Total Leads Generated], IIf(IsNull([Qualified Leads]),0,[Qualified Leads]), IIf(IsNull([Unqualified Leads]),0,[Unqualified Leads]), IIf(IsNull([Uncontacted Leads]),0,[Uncontacted Leads]), IIf(IsNull([To Be Followed Up Leads]),0,[To Be Followed Up Leads]), IIf(IsNull([Terminated Leads]),0,[Terminated Leads]), IIf(IsNull([On Hold Leads]),0,[On Hold Leads]) FROM [SubQry Rpt Count Total Leads Generated], [SubQry Rpt Count Qualified Leads], [SubQry Rpt Count Unqualified Leads], [SubQry Rpt Count Uncontacted Leads], [SubQry Rpt Count Followed Up Leads], [SubQry Rpt Count Terminated Leads], [SubQry Rpt Count On Hold Leads]
Qry Report Marketing Leads
Type: Select
SELECT [SubQry Rpt Count Total Leads Generated].[Lead Type], [SubQry Rpt Count Total Leads Generated].[Total Leads Generated], IIf(IsNull([Qualified Leads]),0,[Qualified Leads]), IIf(IsNull([Passed Panel Leads]),0,[Passed Panel Leads]), IIf(IsNull([Exited Leads]),0,[Exited Leads]) FROM [SubQry Rpt Count Total Leads Generated], [SubQry Rpt Count Qualified Leads], [SubQry Rpt Count Passed Panel Leads], [SubQry Rpt Count Exited Leads]
Qry Report Marketing Pre-Unqualified Leads
Type: Select
SELECT Entrepreneurs.[Date Record Created], Entrepreneurs.[Reference Number], [Lead Types].[Lead Type], [First Name] & \, Entrepreneurs.[EOI Business Name], Entrepreneurs.[Email Address], ProcessStatus.Status, UnqualifiedReason.[Unqualified Reason], ProcessStatus.[Process Status ID], UnqualifiedReason.[Unqualified Reason ID] FROM [Entrepreneurs], [Lead Types], [ProcessStatus], [UnqualifiedReason] WHERE (((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Marketing Lead Report Date
Qry Report More Than 3 Follow Ups
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], [SubQry Rpt More Than 3 Follow Ups Count].[Number Follow Up], Entrepreneurs.[Process Status ID], Entrepreneurs.[Date Status Changed], [Lead Types].[Lead Type], Entrepreneurs.[Status Modified By], [First Name] & \, [Entrepreneur Company].[Company Name], Entrepreneurs.[Telephone Number], Entrepreneurs.OwnedBy FROM [Entrepreneurs], [SubQry Rpt More Than 3 Follow Ups Count], [Entrepreneur Company], [Lead Types] WHERE ((([SubQry Rpt More Than 3 Follow Ups Count].[Number Follow Up])>3) And ((Entrep
Qry Report Opal Prin Proj Summary Company Contracts by End Date
Type: Select
((([SubQry Rpt Opal Principal Project Summary Criteria].[Contract End Date]) Is
Qry Report Opal Prin Proj Summary Weighted Companies
Type: Select
SELECT [SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project ID], [SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project], [SubQry Rpt Opal Principal Project Summary Criteria].[Delivery Location], Count([SubQry Rpt Opal Principal Project Summary Criteria].[Entrepreneur Company, Sum([SubQry Rpt Opal Principal Project Summary Criteria].[Allocated Weight]) FROM [SubQry Rpt Opal Principal Project Summary Criteria]
Qry Report Opal Prin Proj Summary Weighted EPs and Comp by DL
Type: Select
SELECT [SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc].[Company Deliv, [SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc].[Delivery Loca, [SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc].[Number EPs], [SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc].[Number Compa, [SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc].[Weighted Num FROM [SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc], [SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc]
Qry Report Opal Principal Project Companies Required
Type: Select
SELECT [Principal Projects].[Principal Project Status ID], [Principal] & \, [Qry Sum Companies Required by Principal Project].[Companies Required], IIf(IsNull([Number of Companies]),0,[Number of Companies]), IIf(([Companies Required]-[Number Active])<0,0,[Companies Required]-[Number Acti, [Qry Get Delivery Locations Allowed by Principal Project].[Delivery Location] FROM [Principals], [Principal Projects], [Qry Get Delivery Locations Allowed by Principal Project], [Qry Sum Companies Required by Principal Project], [SubQry Rpt Opal Prin Proj Summary Count Active Comp] WHERE ((([Principal Projects].[Principal Project Status ID])=2) AND (([Qry Get Deliver
Qry Report Opal Principal Project Count Comp Req _1 Del Loc
Type: Select
SELECT Count([SubQry Rpt Opal Prin Proj Summary Comp Required >1 Del Loc].[Principal Pr FROM [SubQry Rpt Opal Prin Proj Summary Comp Required >1 Del Loc]
Qry Report Opal Principal Project Sum Comp Req _1 Del Loc
Type: Select
SELECT Sum([SubQry Rpt Opal Prin Proj Summary Comp Required >1 Del Loc].[Companies Requ FROM [SubQry Rpt Opal Prin Proj Summary Comp Required >1 Del Loc]
Qry Report Opal Principal Project Sum Comp Required 1 Del Loc
Type: Select
SELECT [Qry Get Delivery Locations Allowed by Principal Project].[Delivery Location], Sum([Qry Sum Companies Required by Principal Project].[Companies Required]), [Qry Count Delivery Locations Allowed by Principal Project].[Number Del Loc Allo FROM [Principal Projects], [Qry Sum Companies Required by Principal Project], [Qry Count Delivery Locations Allowed by Principal Project], [Qry Get Delivery Locations Allowed by Principal Project] WHERE ((([Principal Projects].[Principal Project Status ID])=2))
Qry Report Opal Principal Projects by Industry
Type: Select
SELECT [SubQry Rpt Opal Principal Projects by Industry].Industry, [SubQry Rpt Opal Principal Projects by Industry].[Principal Project], IIf(IsNull([Total Spend by Principal Project]),0,[Total Spend by Principal Proje, IIf(IsNull([Total Sponsorship Amt]),0,[Total Sponsorship Amt])+IIf(IsNull([Total, [Rands Required]-[Total Sponsorship], [SubQry Rpt Opal Principal Projects by Industry].[Companies Required], [Qry Count Current Active Allocated Companies On Pgm by Prin Proj].[Number Activ, [Qry Count Exited Companies by Principal Project].[Number Exited Companies], [Qry Count Exited Need Replacement by Principal Project].[Number of Exited Need , [Qry Count Unallocated Companies by Principal Project Recommended].[Unallocated FROM [SubQry Rpt Opal Principal Projects by Industry], [Qry Sum Total Spend by Principal Project], [Qry Sum Total Sponsorship by Principal Project], [Qry Sum Total Replaced Billed to Date by Principal Project], [Qry Count Current Active Allocated Companies On Pgm by Prin Proj], [Qry Count Exited Companies by Principal Project], [Qry Count Exited Need Replacement by Principal Project], [Qry Count Unallocated Companies by Principal Project Recommended]
Qry Report Opal Raizcorpossibles and Part Sponsorship
Type: Select
SELECT [Delivery Locations].[Delivery Location], [Delivery Locations].[Raizcorpossibles Target], IIf(IsNull([Current Raizcorp Possibles]),0,[Current Raizcorp Possibles]), IIf(IsNull([Current Number Part Sponsorship]),0,[Current Number Part Sponsorship, IIf(IsNull([Current Part Sponsorship Amt]),0,[Current Part Sponsorship Amt]) FROM [Qry Get Del Loc Raizcorpossibles Part Sponsorship], [Qry Count Current Raizcorp Possibles by Delivery Location], [Delivery Locations], [Qry Count Current Part Sponsorship by Delivery Location]
Qry Report P3 Graduates Not Active Exited 5 Months Ago
Type: Select
SELECT [Entrepreneur Company Programme Years].[Product ID], [Entrepreneur Company].[Company Status ID], [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], CompanyStatus.Status, DateAdd(\, [Entrepreneur Company Programme Years].[Date Status Changed], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Brief Description of Business], [First Name] & \, Entrepreneurs.[Telephone Number], Entrepreneurs.[Email Address] FROM [Entrepreneur Company Programme Years], [Entrepreneur Company], [Entrepreneurs], [CompanyStatus], [CompanyProgrammeYearStatus], [Qry Get Last Programme Year ID by Company] WHERE ((([Entrepreneur Company Programme Years].[Product ID])=7) AND (([Entrepreneur C
Qry Report Panel Passes per Scout
Type: Select
SELECT [Qry Get Owned By Panels Passed by Scout].OwnedBy, [Qry Count Total Assessments Taken by Scout].[Total Assessments Taken], [Qry Count Total Assessments Passed by Scout].[Total Assessments Passed], IIf([Total Assessments Taken]<>0,[Total Assessments Passed]/[Total Assessments T, [Qry Count Total Panels Held by Scout].[Total Panels Held], [Qry Count Total Panels Passed by Scout].[Total Panels Passed], IIf([Total Panels Held]<>0,[Total Panels Passed]/[Total Panels Held]) FROM [Qry Count Total Panels Held by Scout], [Qry Count Total Panels Passed by Scout], [Qry Count Total Assessments Taken by Scout], [Qry Count Total Assessments Passed by Scout], [Qry Get Owned By Panels Passed by Scout]
Qry Report Part Sponsorship Entrepreneurs
Type: Select
SELECT vwPurpleReportPartSponsorshipEntrepreneurs.[Entrepreneur Company ID], [First Name] & \, [Principal] & \, IIf([Profile Created]=True,\, Int(DateDiff(\, vwPurpleReportPartSponsorshipEntrepreneurs.Gender, vwPurpleReportPartSponsorshipEntrepreneurs.Location FROM [vwPurpleReportPartSponsorshipEntrepreneurs]
Qry Report Part Sponsorship
Type: Select
SELECT [SubQry Rpt Part Sponsorship].[Entrepreneur Company ID], [SubQry Rpt Part Sponsorship].[Company Delivery Location ID], [SubQry Rpt Part Sponsorship].[Company Programme Year Status ID], [SubQry Rpt Part Sponsorship].[Programme Year Status], [SubQry Rpt Part Sponsorship].[Company Status ID], [SubQry Rpt Part Sponsorship].[Company Status], [SubQry Rpt Part Sponsorship].[Delivery Location], [SubQry Rpt Part Sponsorship].[Company Name], [SubQry Rpt Part Sponsorship].Industry, [SubQry Rpt Part Sponsorship].[Percentage Black Owned], [SubQry Rpt Part Sponsorship].[Percentage Women Black Owned], [SubQry Rpt Part Sponsorship].[Brief Description of Business], [SubQry Rpt Part Sponsorship].Product, [SubQry Rpt Part Sponsorship].[Programme Year] FROM [SubQry Rpt Part Sponsorship]
Qry Report Partner Elite Get Status Step 1
Type: Select
SELECT [Qry Report Partner Elite Pipeline Step 1].Status, [Qry Report Partner Elite Pipeline Step 1].[Sort Order] FROM [Qry Report Partner Elite Pipeline Step 1]
Qry Report Partner Elite Get Steps 2-7
Type: Select
SELECT [Qry Report Partner Elite Pipeline Step 2-7].[Process Step], [Qry Report Partner Elite Pipeline Step 2-7].[Step Number] FROM [Qry Report Partner Elite Pipeline Step 2-7]
Qry Report Partner Elite Pipeline Get Lead Types
Type: Select
-- Unable to parse query definition
Qry Report Partner Elite Pipeline Step 1
Type: Select
SELECT Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], ProcessStatus.Status, ProcessStatus.[Sort Order], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus], [Lead Types] WHERE (((Entrepreneurs.[Division ID])=3) AND ((ProcessStatus.[Step Number])=1))
Qry Report Partner Elite Pipeline Step 2-7
Type: Select
SELECT Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], ProcessStatus.[Step Number], ProcessStep.[Process Step], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus], [Lead Types], [ProcessStep] WHERE (((Entrepreneurs.[Division ID])=3))
Qry Report Partner Elite Pipeline Unqualified or Terminated
Type: Select
SELECT Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus], [Lead Types] WHERE (((Entrepreneurs.[Division ID])=3) AND ((Entrepreneurs.[Process Status ID])=41 O
Qry Report Partner Elite Summary
Type: Select
SELECT Entrepreneurs.[Division ID], [First Name] & \, [Entrepreneur Company].[Company Name], IndustryLookup.Industry, ProcessStatus.Status, [Qry Get Last Note by Entrepreneur].[Note Date], [Qry Get Last Note by Entrepreneur].Notes, ProcessStatus.[Step Number] FROM [Entrepreneurs], [ProcessStatus], [Entrepreneur Company], [Qry Get Last Note by Entrepreneur], [IndustryLookup] WHERE (((Entrepreneurs.[Division ID])=3) AND ((ProcessStatus.[Step Number])>=1 And (Pr
Qry Report Percent Dropoff After 1st Meeting
Type: Select
SELECT [SubQry Rpt Percent Dropoff After 1st Meeting Count 1st Meeting].[Number EPs Com, [SubQry Rpt Percent Dropoff After 1st Meeting Cnt More Than Step2].[Number EPs M, [SubQry Rpt Percent Dropoff After 1st Meeting Cnt Less Than Step2].[Number EPs L, [Number EPs Complete First Meeting]-[Number EPs More Than Step 2]-[Number EPs Le, IIf([Number EPs Complete First Meeting]=0 Or IsNull([Number EPs Complete First M FROM [SubQry Rpt Percent Dropoff After 1st Meeting Count 1st Meeting], [SubQry Rpt Percent Dropoff After 1st Meeting Cnt More Than Step2], [SubQry Rpt Percent Dropoff After 1st Meeting Cnt Less Than Step2]
Qry Report Percentage Moved Last Week Digital
Type: Select
SELECT [SubQry Rpt Percentage Moved Last Week Digital].[Delivery Location ID], [SubQry Rpt Percentage Moved Last Week Digital].[Distribution Model], [SubQry Rpt Percentage Moved Last Week Digital].[Delivery Location], [SubQry Rpt Percentage Moved Last Week Digital].[Number Steps 1 to 7], [SubQry Rpt Percentage Moved Last Week Digital].[Entrepreneurs Moved Last Week], [Entrepreneurs Moved Last Week]/[Number Steps 1 to 7], IIf(IsNull([Total Moved Last Week]),0,[Total Moved Last Week]), [Qry Count Entrepreneur Steps 1 to 7 Digital Process].[Total Steps 1 to 7], [Total Number Moved]/[Total Steps 1 to 7] FROM [SubQry Rpt Percentage Moved Last Week Digital], [Qry Count Entrepreneur Moved Last Week Digital Process], [Qry Count Entrepreneur Steps 1 to 7 Digital Process]
Qry Report Percentage Moved Last Week Manual
Type: Select
SELECT [SubQry Rpt Percentage Moved Last Week Manual].[Delivery Location ID], [SubQry Rpt Percentage Moved Last Week Manual].[Distribution Model], [SubQry Rpt Percentage Moved Last Week Manual].[Delivery Location], [SubQry Rpt Percentage Moved Last Week Manual].[Number Steps 1 to 7], [SubQry Rpt Percentage Moved Last Week Manual].[Entrepreneurs Moved Last Week], [Entrepreneurs Moved Last Week]/[Number Steps 1 to 7], IIf(IsNull([Total Moved Last Week]),0,[Total Moved Last Week]), [Qry Count Entrepreneur Steps 1 to 7 Manual Process].[Total Steps 1 to 7], [Total Number Moved]/[Total Steps 1 to 7] FROM [Qry Count Entrepreneur Steps 1 to 7 Manual Process], [Qry Count Entrepreneur Moved Last Week Manual Process], [SubQry Rpt Percentage Moved Last Week Manual]
Qry Report Pipeline List
Type: Select
SELECT Pipelines.[Pipeline ID], Pipelines.Pipeline, ProcessStatus.[Step Number], ProcessStatus.Status, ProcessStatus.[Sort Order] FROM [Pipelines], [Pipelines Detail], [ProcessStatus]
Qry Report Principal Project Allocation by Entrepreneur
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Process Status ID], [Entrepreneur Company].[Company Status ID], [Principal] & \, CompanyStatus.Status, [Entrepreneur Company].[Company Name], [Entrepreneur Company Programme Years].[Programme Year], [Principal Project Pillars].[BBBEE Pillar], [Entrepreneur Company Principal Projects].[Allocated Amount], [Qry Sum Total Allocated Amt by Company].[Total Allocated Amt], [Entrepreneur Company Programme Years].[Total Programme Amount], [Entrepreneur Company Programme Years].[Total Programme Amount]-[Total Allocated, [First Name] & \ FROM [Principal Projects], [Principals], [Entrepreneurs], [Products], [Principal Project Pillars], [Entrepreneur Company], [Delivery Locations], [Qry Sum Total Allocated Amt by Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [CompanyStatus] WHERE (((Entrepreneurs.[Process Status ID])=91) AND (([Entrepreneur Company].[Company
Qry Report Principal Project Information
Type: Select
SELECT [Principal Projects].[Principal Project ID], Principals.Principal, Principals.[Principal Address 1], Principals.[Principal Address 2], Principals.[Principal Address 3], Principals.[Principal Address 4], [Channel Partners].[Channel Partner], [Contact First Name] & \, IndustryLookup.Industry, Principals.[Industry Notes], Principals.FYE, [Client Tiers].[Client Tier], [Principal Projects].[Project Name], [Principal Projects].[Solutions Architect], [Principal Projects].[Contract Type], PrincipalProjectStatus.Status, [Principal Projects].[Brief Date], [Principal Projects].[Contract Start Date] FROM [Principal Projects], [Principals], [Channel Partners], [IndustryLookup], [PrincipalProjectStatus], [Client Tiers] WHERE ((([Principal Projects].[Principal Project ID])=[Forms]![Frm Principal Project R
Qry Report Process Status All Lead Types
Type: Select
SELECT Count([SubQry Count Process Status All Lead Types Criteria].[Entrepreneur ID]) FROM [SubQry Count Process Status All Lead Types Criteria]
Qry Report Process Status by Delivery Location
Type: Select
SELECT Count([SubQry Count Process Status by Delivery Location Criteria].[Entrepreneur FROM [SubQry Count Process Status by Delivery Location Criteria]
Qry Report Process Status by Lead Type
Type: Select
SELECT Count([SubQry Count Process Status by Lead Type Criteria].[Entrepreneur ID]) FROM [SubQry Count Process Status by Lead Type Criteria]
Qry Report Process Status by Principal Project
Type: Select
SELECT Count([SubQry Count Process Status by Principal Project Criteria].[Entrepreneur FROM [SubQry Count Process Status by Principal Project Criteria]
Qry Report Purple Panelists Summary
Type: Select
SELECT [SubQry Rpt Purple Panelists Summary].[Purple Panelist], IIf(IsNull([Number Attended]),0,[Number Attended]), IIf(IsNull([Number Convened]),0,[Number Convened]), [# Attended]+[# Convened], IIf([Total Panels]=0,0,[Sum of Scores]/[Total Panels]) FROM [SubQry Rpt Purple Panelists Summary], [SubQry Rpt Purple Panelists Attended], [SubQry Rpt Purple Panelists Convened], [SubQry Rpt Purple Panelists Sum Scores]
Qry Report Quartz Leads by Phase
Type: Select
SELECT [Delivery Locations].[Delivery Location], IIf(IsNull([Number Entrepreneurs Phase 1]),0,[Number Entrepreneurs Phase 1]), IIf(IsNull([Number Entrepreneurs Phase 2]),0,[Number Entrepreneurs Phase 2]), IIf(IsNull([Number Entrepreneurs Phase 3]),0,[Number Entrepreneurs Phase 3]), IIf(IsNull([Unallocated Companies]),0,[Unallocated Companies]) FROM [Qry Get Delivery Locations Quartz Lead Phase Report], [Delivery Locations], [Qry Count Entrepreneurs Pipeline Phase 1 by Delivery Location], [Qry Count Entrepreneurs Pipeline Phase 2 by Delivery Location], [Qry Count Entrepreneurs Pipeline Phase 3 by Delivery Location], [Qry Count Unallocated Companies by EP Delivery Location]
Qry Report RAG
Type: Select
SELECT vwPurpleReportRAG.[Principal Project Status ID], vwPurpleReportRAG.[Lump Sum Allocation], vwPurpleReportRAG.[Principal Project ID], [Principal] & \, vwPurpleReportRAG.[BBBEE Pillar], vwPurpleReportRAG.[Brief Date], vwPurpleReportRAG.[Number of Companies Required], vwPurpleReportRAG.[Entrepreneur Delivery Date], vwPurpleReportRAG.[Amount Sponsored], DateDiff(\, IIf([Entrepreneur Delivery Date]<Date(),DateDiff(\, DateDiff(\, IIf(IsNull([Total Sponsorship Amt]),0,[Total Sponsorship Amt])+IIf(IsNull([Total, [Amount Sponsored]-[Total Sponsorship], IIf([Total Days]=0,0,[Current Days]/[Total Days]), IIf([Amount Sponsored]=0,0,[Total Sponsorship]/[Amount Sponsored]), IIf(IsNull([Number Active Allocated Companies]),0,[Number Active Allocated Compa, IIf(IsNull([Number Exited Companies]),0,[Number Exited Companies]), IIf(IsNull([Unallocated Companies]),0,[Unallocated Companies]), [Number of Companies Required]-[Number Active]-[Number Exited]-[Number Unallocat, IIf(IsNull([Number of Replacements Needed]),0,[Number of Replacements Needed]) FROM [vwPurpleReportRAG], [vwPurpleSumTotalReplacedBilledtoDatebyPrinProjectPillar], [vwPurpleSumTotalReplacedSelectionFeebyPrinProjectPillar]
Qry Report Raizcorp Possibilities
Type: Select
SELECT vwPurpleReportRaizcorpPossibilities.[Date Status Changed], DateDiff(\, vwPurpleReportRaizcorpPossibilities.[Company Status ID], vwPurpleReportRaizcorpPossibilities.Status, ProcessStatus.Status, vwPurpleReportRaizcorpPossibilities.[Delivery Location], vwPurpleReportRaizcorpPossibilities.Location, vwPurpleReportRaizcorpPossibilities.[Company Name], [First Name] & \, vwPurpleReportRaizcorpPossibilities.[Telephone Number], vwPurpleReportRaizcorpPossibilities.[Date of Birth], Int(DateDiff(\, vwPurpleReportRaizcorpPossibilities.Gender, vwPurpleReportRaizcorpPossibilities.[Email Address], vwPurpleReportRaizcorpPossibilities.Industry, vwPurpleReportRaizcorpPossibilities.[Brief Description of Business], vwPurpleReportRaizcorpPossibilities.[Percentage Black Owned], vwPurpleReportRaizcorpPossibilities.[Percentage Women Black Owned], [Principal] & \, vwPurpleReportRaizcorpPossibilities.Product, IIf([Profile Created]=True,\, vwPurpleReportRaizcorpPossibilities.[Note Date], vwPurpleReportRaizcorpPossibilities.Notes, vwPurpleReportRaizcorpPossibilities.[Product Pgm Yr], vwPurpleReportRaizcorpPossibilities.[Date Pgm Yr Status Changed] FROM [vwPurpleReportRaizcorpPossibilities], [ProcessStatus]
Qry Report Raizcorpossible Companies Email
Type: Select
SELECT [Entrepreneur Company].[Company Status ID], Entrepreneurs.[Distribution Model ID], [Distribution Models].[Distribution Model], Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Company Name], [First Name] & \, Entrepreneurs.[Email Address] FROM [Entrepreneurs], [Entrepreneur Company], [Distribution Models] WHERE ((([Entrepreneur Company].[Company Status ID])=2 Or ([Entrepreneur Company].[Com
Qry Report Recommended Principal Project Allocation
Type: Select
SELECT [SubQry Rpt Recommended Principal Project Allocation].[The Principal Project ID], [Principal] & \, [SubQry Rpt Recommended Principal Project Allocation].Entrepreneur, [SubQry Rpt Recommended Principal Project Allocation].[The Status], [SubQry Rpt Recommended Principal Project Allocation].[Allocated Amount], IIf(IsNull([Total Spend by Principal Project]),0,[Total Spend by Principal Proje, [SubQry Rpt Recommended Principal Project Allocation].[Company Name] FROM [SubQry Rpt Recommended Principal Project Allocation], [Principal Projects], [Principals], [Products], [Qry Sum Total Spend by Principal Project], [Delivery Locations]
Qry Report Selection Daily Team Activity by Delivery Location
Type: Select
SELECT [Delivery Locations].[Distribution Model ID], [Delivery Locations].Active, [Delivery Locations].[Delivery Location], [SubQry Rpt Count Entrepreneurs In the Pipeline by Del Loc].[Number of EPs Pipel, [SubQry Rpt Count Entrepreneurs With Pipeline Moves by Del Loc].[Number of EPs M, [Number of EPs Moved]/[Number of EPs Pipeline], [SubQry Rpt Count Meetings by Del Loc].[Number of Meetings], [SubQry Rpt Count Terminations by Del Loc].[Number of Terminations], [SubQry Rpt Count Unqualified by Del Loc].[Number of Unqualified] FROM [Delivery Locations], [SubQry Rpt Count Entrepreneurs With Pipeline Moves by Del Loc], [SubQry Rpt Count Entrepreneurs In the Pipeline by Del Loc], [SubQry Rpt Count Meetings by Del Loc], [SubQry Rpt Count Terminations by Del Loc], [SubQry Rpt Count Unqualified by Del Loc] WHERE ((([Delivery Locations].[Distribution Model ID])=Forms![Frm Reports Date Distrib
Qry Report Selection Daily Team Activity
Type: Select
SELECT [SubQry Rpt Get Owned By].OwnedBy, [SubQry Rpt Count Entrepreneurs In the Pipeline].[Number of EPs Pipeline], [SubQry Rpt Count Entrepreneurs With Pipeline Moves].[Number of EPs Moved], [Number of EPs Moved]/[Number of EPs Pipeline], [SubQry Rpt Count Meetings by Owned By].[Number of Meetings], [SubQry Rpt Count Terminations by Owned By].[Number of Terminations], [SubQry Rpt Count Unqualified by Owned By].[Number of Unqualified] FROM [SubQry Rpt Get Owned By], [SubQry Rpt Count Entrepreneurs In the Pipeline], [SubQry Rpt Count Entrepreneurs With Pipeline Moves], [SubQry Rpt Count Meetings by Owned By], [SubQry Rpt Count Terminations by Owned By], [SubQry Rpt Count Unqualified by Owned By]
Qry Report Selection Team Activity Summary
Type: Select
SELECT [Delivery Locations].[Delivery Location], [SubQry Rpt Selection Team Summary Total Leads Generated].[Total Leads Generated, IIf(IsNull([Total Qualified]),0,[Total Qualified]), IIf(IsNull([Total Passed Assessment]),0,[Total Passed Assessment]), IIf(IsNull([Total Passed Panel]),0,[Total Passed Panel]), IIf(IsNull([Total Graduated Off]),0,[Total Graduated Off]), IIf(IsNull([Total Non Graduate]),0,[Total Non Graduate]), IIf(IsNull([Total On Programme]),0,[Total On Programme]) FROM [SubQry Rpt Selection Team Summary Total Leads Generated], [Delivery Locations], [SubQry Rpt Selection Team Summary Total Qualified], [SubQry Rpt Selection Team Summary Total Passed Assessment], [SubQry Rpt Selection Team Summary Total Passed Panel], [SubQry Rpt Selection Team Summary Total Graduated Off], [SubQry Rpt Selection Team Summary Total Non Graduate], [SubQry Rpt Selection Team Summary Total On Programme]
Qry Report Selection Team Activity Times by Delivery Location
Type: Select
SELECT Entrepreneurs.[Delivery Location ID], [Delivery Locations].[Delivery Location], ProcessStatus.Status, ProcessStatus.[Sort Order], Sum(ProcessStatus.[Time Unit]) FROM [ProcessStatus], [Entrepreneur Status History], [Entrepreneurs], [Delivery Locations] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=[Forms]![Frm Selection
Qry Report Selection Team Activity Times by Modified By
Type: Select
SELECT [Entrepreneur Status History].[Status Modified By], ProcessStatus.Status, ProcessStatus.[Sort Order], Sum(ProcessStatus.[Time Unit]) FROM [ProcessStatus], [Entrepreneur Status History] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=[Forms]![Frm Selection
Qry Report Selection Team Call Activity
Type: Select
SELECT [SubQry Rpt Get Modified By].[Delivery Location], [SubQry Rpt Get Modified By].[Status Modified By], IIf(IsNull([Number of Unqualified]),0,[Number of Unqualified]), IIf(IsNull([Number of Followed Up]),0,[Number of Followed Up]), IIf(IsNull([Number of First Meeting Setup]),0,[Number of First Meeting Setup]), [# of Unqualified]+[# of Followed Up]+[# of First Meeting Setup] FROM [SubQry Rpt Get Modified By], [SubQry Rpt Count Unqualified by Modified By], [SubQry Rpt Count Followed Up by Modified By], [SubQry Rpt Count First Meeting Setup by Modified By]
Qry Report Selection Team Targets
Type: Select
SELECT [Qry Get OwnedBy for Selection Team Target Report].OwnedBy, [Qry Count Entreprenur Steps Total at 1].[Total at Step 1], [Qry Count Entreprenur Steps Total at 2].[Total at Step 2], [Qry Count Entreprenur Steps Total at 1 and 2].[Total at Step 1 and 2], [Total at Step 1 and 2]/[Total at Step 1], [Qry Count Entreprenur Steps Total at 3].[Total at Step 3], [Qry Count Entreprenur Steps Total at 1 and 3].[Total at Step 1 and 3], [Total at Step 1 and 3]/[Total at Step 1], [Qry Count Entreprenur Steps Total at 4].[Total at Step 4], [Qry Count Entreprenur Steps Total at 1 and 4].[Total at Step 1 and 4], [Total at Step 1 and 4]/[Total at Step 1], [Qry Count Entreprenur Steps Total at 7].[Total at Step 7], [Qry Count Entreprenur Steps Total at 1 and 7].[Total at Step 1 and 7], [Total at Step 1 and 7]/[Total at Step 1], [Qry Count Entreprenur Steps Total at 8].[Total at Step 8], [Qry Count Entreprenur Steps Total at 1 and 8].[Total at Step 1 and 8], [Total at Step 1 and 8]/[Total at Step 1] FROM [Qry Get OwnedBy for Selection Team Target Report], [Qry Count Entreprenur Steps Total at 1], [Qry Count Entreprenur Steps Total at 1 and 2], [Qry Count Entreprenur Steps Total at 2], [Qry Count Entreprenur Steps Total at 4], [Qry Count Entreprenur Steps Total at 7], [Qry Count Entreprenur Steps Total at 3], [Qry Count Entreprenur Steps Total at 1 and 3], [Qry Count Entreprenur Steps Total at 1 and 4], [Qry Count Entreprenur Steps Total at 1 and 7], [Qry Count Entreprenur Steps Total at 8], [Qry Count Entreprenur Steps Total at 1 and 8] WHERE ((([Qry Get OwnedBy for Selection Team Target Report].OwnedBy) Is Not Null))
Qry Report Step Movement
Type: Select
-- Unable to parse query definition
Qry Report Steps Skipped Error Report
Type: Select
-- Unable to parse query definition
Qry Report Termination Analysis Data
Type: Select
SELECT vwPurpleReportTerminationAnalysisData.[Entrepreneur ID], vwPurpleReportTerminationAnalysisData.[Entrepreneur Company ID], vwPurpleReportTerminationAnalysisData.[Date Status Changed], vwPurpleReportTerminationAnalysisData.[Process Status ID], vwPurpleReportTerminationAnalysisData.[Step Number], [First Name] & \, vwPurpleReportTerminationAnalysisData.Status, vwPurpleReportTerminationAnalysisData.[History Date Status Changed], vwPurpleReportTerminationAnalysisData.[Company Name], vwPurpleReportTerminationAnalysisData.[Lead Type], vwPurpleReportTerminationAnalysisData.Industry, [Principal] & \, vwPurpleReportTerminationAnalysisData.[Recommended Product], vwPurpleReportTerminationAnalysisData.[Termination Reason] FROM [vwPurpleReportTerminationAnalysisData] WHERE (((vwPurpleReportTerminationAnalysisData.[Date Status Changed])>=[Forms]![Frm Re
Qry Report Termination Analysis Successful Data
Type: Select
SELECT vwPurpleReportTerminationAnalysisSuccessfulData.[Entrepreneur ID], vwPurpleReportTerminationAnalysisSuccessfulData.[Entrepreneur Company ID], vwPurpleReportTerminationAnalysisSuccessfulData.[Date Status Changed], vwPurpleReportTerminationAnalysisSuccessfulData.[Process Status ID], vwPurpleReportTerminationAnalysisSuccessfulData.[Step Number], [First Name] & \, vwPurpleReportTerminationAnalysisSuccessfulData.Status, vwPurpleReportTerminationAnalysisSuccessfulData.[Company Name], vwPurpleReportTerminationAnalysisSuccessfulData.[Lead Type], vwPurpleReportTerminationAnalysisSuccessfulData.Industry, [Principal] & \, vwPurpleReportTerminationAnalysisSuccessfulData.[Recommended Product] FROM [vwPurpleReportTerminationAnalysisSuccessfulData] WHERE (((vwPurpleReportTerminationAnalysisSuccessfulData.[Date Status Changed])>=[Form
Qry Report User Permissions
Type: Select
SELECT [DatabaseUsers Module Permissions].[Module Permission], DatabaseUsers.LEVEL, DatabaseUsers.Username FROM [DatabaseUsers], [DatabaseUsers Module Permissions] WHERE (((DatabaseUsers.LEVEL)<>\"disabled\"))
Qry Report VA Packs Required in Four Weeks
Type: Select
SELECT [Principal Projects].[Principal Project ID], [Principal Projects].[Date Principal Requires Packs], [Principal] & \, Principals.FYE, [Principal Projects].[Solutions Architect] FROM [Principals], [Principal Projects] WHERE ((([Principal Projects].[Date Principal Requires Packs])>Date() And ([Principal
Qry Report VA Packs Required in Two Weeks
Type: Select
SELECT [Principal Projects].[Principal Project ID], [Principal Projects].[Date Principal Requires Packs], [Principal] & \, Principals.FYE, [Principal Projects].[Solutions Architect] FROM [Principals], [Principal Projects] WHERE ((([Principal Projects].[Date Principal Requires Packs])>Date() And ([Principal
Qry Report Workshop Attendance Register
Type: Select
SELECT Entrepreneurs.[Process Status ID], Entrepreneurs.[Recommended Principal Project ID], Entrepreneurs.[Delivery Location ID], [First Name] & \, ProcessStatus.Status FROM [Entrepreneurs], [Entrepreneur Company], [ProcessStatus] WHERE (((Entrepreneurs.[Process Status ID])=76 Or (Entrepreneurs.[Process Status ID])=
Qry Report Writer
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], [Qry Get Current Contract Info by Company].[Principal Project ID], Entrepreneurs.[Process Status ID], [First Name] & \, [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], ProcessStatus.[Step Number], ProcessStatus.Status, Entrepreneurs.Gender, Entrepreneurs.[Identity Number], Entrepreneurs.[Date of Birth], [Lead Types].[Lead Type], Entrepreneurs.Province, [Delivery Locations].[Delivery Location], Entrepreneurs.OwnedBy, Entrepreneurs.Location, Entrepreneurs.[Information 1], Entrepreneurs.[Information 2], Entrepreneurs.[Information 3], IndustryLookup.Industry, [Entrepreneur Company].[Business Registration Date], [Entrepreneur Company].[Sworn Affidavit Date], [Entrepreneur Company].CompanyReg, [Entrepreneur Company].[Brief Description of Business], [Entrepreneur Company].[Average Monthly Turnover], [Entrepreneur Company].[Years in Business], [Qry Get Current Contract Info by Company].Principal, [Qry Get Current Contract Info by Company].[Principal Project], [Qry Get Current Contract Info by Company].Product, [Qry Get Current Contract Info by Company].[Total Programme Amount], [Qry Get Current Contract Info by Company].[BBBEE Pillar], [Qry Get Current Contract Info by Company].[Total Allocated Amt], Entrepreneurs.[Telephone Number], Entrepreneurs.[Email Address], [Entrepreneur Company].[BEE Level], [Entrepreneur Company].[Percentage Black Owned], [Entrepreneur Company].[Percentage Women Black Owned], [Principals].[Principal] & \, Products.Product, Entrepreneurs.[Process Date], IIf([Entrepreneurial Assessment Results]=1,\, Entrepreneurs.[EA Marker], IIf([PP Results]=1,\, vwPurpleGetLastNotebyEntrepreneur.[Note Date], vwPurpleGetLastNotebyEntrepreneur.Notes FROM [IndustryLookup], [Entrepreneurs], [ProcessStatus], [Lead Types], [Principal Projects], [Principals], [Entrepreneur Company], [Products], [Delivery Locations], [Qry Get Current Contract Info by Company], [vwPurpleGetLastNotebyEntrepreneur]
QRY Restore Deleted leads
Type: Delete
SELECT [Restore Deleted Leads].[Entrepreneur ID], [Restore Deleted Leads].[Reference Number], [Restore Deleted Leads].[Date Record Created], [Restore Deleted Leads].[Lead Type ID], [Restore Deleted Leads].[Division ID], [Restore Deleted Leads].[Date of Birth], [Restore Deleted Leads].[First Name], [Restore Deleted Leads].Surname, [Restore Deleted Leads].[EOI SA Identity Number], [Restore Deleted Leads].[EOI Citizenship Type], [Restore Deleted Leads].[EOI Date of Naturalisation], [Restore Deleted Leads].[EOI Business Name], [Restore Deleted Leads].[EOI Business Address 1], [Restore Deleted Leads].[EOI Business Address 2], [Restore Deleted Leads].[EOI Business Address 3], [Restore Deleted Leads].[EOI Business Postal Code], [Restore Deleted Leads].[EOI Industry ID], [Restore Deleted Leads].[EOI Brief Description of Business], [Restore Deleted Leads].[EOI Enterprise Type], [Restore Deleted Leads].[EOI Percent of Ownership], [Restore Deleted Leads].[EOI Average Monthly Turnover], [Restore Deleted Leads].[EOI Years in Business], [Restore Deleted Leads].[EOI Do you have a full time job], [Restore Deleted Leads].[Entrepreneur Company ID], [Restore Deleted Leads].[Shareholding Percentage], [Restore Deleted Leads].[Telephone Number], [Restore Deleted Leads].[Second Telephone Number], [Restore Deleted Leads].[Email Address], [Restore Deleted Leads].[Alternative Email Address], [Restore Deleted Leads].Race, [Restore Deleted Leads].Gender, [Restore Deleted Leads].[SA Citizen], [Restore Deleted Leads].[Identity Number], [Restore Deleted Leads].SAID, [Restore Deleted Leads].[Profile Created], [Restore Deleted Leads].[Full Time], [Restore Deleted Leads].Province, [Restore Deleted Leads].Location, [Restore Deleted Leads].Country, [Restore Deleted Leads].[Access to PC], [Restore Deleted Leads].[Access to Laptop], [Restore Deleted Leads].[Access to Smartphone], [Restore Deleted Leads].[Quality of Connectivity], [Restore Deleted Leads].[Use Tech Resources For Sessions], [Restore Deleted Leads].[Source Category], [Restore Deleted Leads].[Source Detail], [Restore Deleted Leads].[Process Date], [Restore Deleted Leads].[Pipeline ID], [Restore Deleted Leads].[Process Status ID], [Restore Deleted Leads].[Process Status Notes], [Restore Deleted Leads].[Date Status Changed], [Restore Deleted Leads].[Status Modified By], [Restore Deleted Leads].[Override Status Rules], [Restore Deleted Leads].[Distribution Model ID], [Restore Deleted Leads].[Delivery Location ID], [Restore Deleted Leads].[Termination Reason ID], [Restore Deleted Leads].[Unqualified Reason ID], [Restore Deleted Leads].[Blue Eagle Recommendation Date], [Restore Deleted Leads].[Blue Eagle Exported], [Restore Deleted Leads].[Recommended Principal Project ID], [Restore Deleted Leads].[Recommended Product ID], [Restore Deleted Leads].[Recommended BBBEE Pillar], [Restore Deleted Leads].[Primary Entrepreneur], [Restore Deleted Leads].Notes, [Restore Deleted Leads].[Allocation ID], [Restore Deleted Leads].[Student ID], [Restore Deleted Leads].[Style Questionnaire Score], [Restore Deleted Leads].[Style Questionnaire Results], [Restore Deleted Leads].[Personal Audit Score], [Restore Deleted Leads].[Personal Audit Results], [Restore Deleted Leads].[Urgency Result], [Restore Deleted Leads].[Financial Literacy Result], [Restore Deleted Leads].[Entrepreneurial Assessment Results], [Restore Deleted Leads].[EA Date], [Restore Deleted Leads].[EA Marker], [Restore Deleted Leads].[EA Retake Results], [Restore Deleted Leads].[EA Retake Date], [Restore Deleted Leads].[EA Retake Marker], [Restore Deleted Leads].[Purple Panel Score], [Restore Deleted Leads].[PP Results], [Restore Deleted Leads].[Date Panel Held], [Restore Deleted Leads].[Certified ID Copy], [Restore Deleted Leads].[Date ID Certified], [Restore Deleted Leads].[RSA Naturalisation Certificate], [Restore Deleted Leads].[RSA Naturalisation Issue Date], [Restore Deleted Leads].[Home Affairs Doc], [Restore Deleted Leads].[Date Entered South Africa], [Restore Deleted Leads].[Other Proof of Naturalisation], [Restore Deleted Leads].[Other Proof Issue Date], [Restore Deleted Leads].[Employee Payslips], [Restore Deleted Leads].[Emplouee Number or Start Date], [Restore Deleted Leads].[Employee Contracts], [Restore Deleted Leads].[Employee Contract Start Date], [Restore Deleted Leads].[EMP 201], [Restore Deleted Leads].[EMP 201 Last Payment Date], [Restore Deleted Leads].IRP5, [Restore Deleted Leads].[Tax Reference Number], [Restore Deleted Leads].[CIPS Documents], [Restore Deleted Leads].[Sworn Affidavit BEE], [Restore Deleted Leads].[BBBEE Certificate Issued], [Restore Deleted Leads].[Tax Clearance Certificate], [Restore Deleted Leads].[VAT Registration Document], [Restore Deleted Leads].[Proof of Turnover], [Restore Deleted Leads].[Minimum Bank Statements], [Restore Deleted Leads].[Audited Financials], [Restore Deleted Leads].[Information 1], [Restore Deleted Leads].[Information 2], [Restore Deleted Leads].[Information 3], [Restore Deleted Leads].[Information 4], [Restore Deleted Leads].[Information 5], [Restore Deleted Leads].OwnedBy, [Restore Deleted Leads].[Headhunted By], [Restore Deleted Leads].Headhunted, [Restore Deleted Leads].[Modified By], [Restore Deleted Leads].[Date Modified], [Restore Deleted Leads].[Date Blue Heart Email Sent], [Restore Deleted Leads].[Other Incubator], [Restore Deleted Leads].[Other Incubator Text], [Restore Deleted Leads].[Access to Tablet], [Restore Deleted Leads].[Digital State of Business], [Restore Deleted Leads].[Digital Fulltime in Business], [Restore Deleted Leads].[Digital More Than One Partner], [Restore Deleted Leads].[Digital More Than One Business], [Restore Deleted Leads].[Digital Bank Account], [Restore Deleted Leads].[Digital Fulltime Employees], [Restore Deleted Leads].[Digital Signed Employee Contracts], [Restore Deleted Leads].[Digital Currently Incubated], [Restore Deleted Leads].[Digital Incubation Type], [Restore Deleted Leads].[Digital Comodities], [Restore Deleted Leads].[Digital Motivation], [Restore Deleted Leads].[Blue Heart Score Calculated], [Restore Deleted Leads].[Date Digital First Meeting Captured], [Restore Deleted Leads].[SharePoint Link] FROM [Restore Deleted Leads]
Qry SubFrm Principal Project Pillar Supporting Documents
Type: Select
SELECT [Principal Project Pillars].[Principal Project Pillar ID], IIf([Supporting Doc Affidavit (EME)]=True,\ FROM [Principal Project Pillars]
Qry SubRpt Allocation by Principal Project
Type: Select
SELECT vwPurpleSubRptAllocationbyPrincipalProject.[Principal Project ID], vwPurpleSubRptAllocationbyPrincipalProject.[BBBEE Pillar Description], vwPurpleSubRptAllocationbyPrincipalProject.[Company Status ID], IIf(IsNull([Programme Year Status]),[Status],[Programme Year Status]), IIf([Ring Fencing]=True,\, [Principal] & \, vwPurpleSubRptAllocationbyPrincipalProject.[Company Name], vwPurpleSubRptAllocationbyPrincipalProject.[Replacement Status], vwPurpleSubRptAllocationbyPrincipalProject.[BBBEE Pillar] FROM [vwPurpleSubRptAllocationbyPrincipalProject], [Qry Count Companies by Principal Project Principal Report], [Qry Sum Total Replaced Billed to Date by Principal Project], [Qry Sum Total Replaced Selection Fee by Principal Project], [Qry Count Entrepreneurs by Principal Project Principal Report], [Qry Sum Total Spend by Principal Project] WHERE (((vwPurpleSubRptAllocationbyPrincipalProject.[Principal Project ID])=Forms![Frm
Qry SubRpt Allocation Replaced by Principal Project
Type: Select
SELECT vwPurpleSubRptAllocationReplacedbyPrincipalProject.[BBBEE Pillar Description], vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Company Status ID], IIf(IsNull([Programme Year Status]),[Status],[Programme Year Status]), [Principal] & \, vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Principal Project ID], vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Company Name], vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Replacement Status], vwPurpleSubRptAllocationReplacedbyPrincipalProject.[BBBEE Pillar] FROM [Qry Sum Total Spend by Principal Project], [vwPurpleSubRptAllocationReplacedbyPrincipalProject] WHERE (((vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Principal Project ID])=[F
Qry SubRpt BEE Certificate Blank
Type: Select
SELECT Entrepreneurs.[Process Status ID], [Entrepreneur Company].[Company Status ID], Entrepreneurs.[Delivery Location ID], [First Name] & \, [Entrepreneur Company].[Company Name], Divisions.Division, [Qry Get Current Contract Info by Company].Product, IIf(IsNull([Entrepreneur Company].[Company Status ID]),[ProcessStatus].[Status],, [Product Divisions].[BEE Certificate Required], [Entrepreneur Company].[BEE Certificate Expire Date] FROM [Entrepreneurs], [Entrepreneur Company], [ProcessStatus], [Product Divisions], [Divisions], [Qry Get Current Contract Info by Company], [CompanyStatus] WHERE (((Entrepreneurs.[Process Status ID])<>41 And (Entrepreneurs.[Process Status ID]
Qry SubRpt Company Principal Project by Programme Year
Type: Select
SELECT [Entrepreneur Company Principal Projects].[Entrepreneur Company Programme Years , [Principal] & \ FROM [Principal Project Pillars], [Principal Projects], [Principals], [Entrepreneur Company Principal Projects]
Qry SubRpt Count Records Created by Del Loc
Type: Select
SELECT [Delivery Locations].[Distribution Model ID], [Delivery Locations].Active, [Delivery Locations].[Delivery Location], [SubQry Count Records Created Dist Model Criteria].[Delivery Location ID], Count([SubQry Count Records Created Dist Model Criteria].[Entrepreneur ID]) FROM [SubQry Count Records Created Dist Model Criteria], [Delivery Locations]
Qry SubRpt Count Records Created
Type: Select
SELECT Count([SubQry Count Records Created Criteria].[Entrepreneur ID]) FROM [SubQry Count Records Created Criteria]
Qry SubRpt Count Step 1 Status by Del Loc
Type: Select
SELECT [Delivery Locations].[Delivery Location], [SubQry Count Step 1 Status Dist Model Criteria].Status, Count([SubQry Count Step 1 Status Dist Model Criteria].[Entrepreneur ID]) FROM [SubQry Count Step 1 Status Dist Model Criteria], [Delivery Locations]
Qry SubRpt Count Step 1 Status
Type: Select
SELECT [SubQry Count Step 1 Status Criteria].Status, Count([SubQry Count Step 1 Status Criteria].[Entrepreneur ID]) FROM [SubQry Count Step 1 Status Criteria]
Qry SubRpt Daily Lead Summary Delivery RC Poss All Divs
Type: Select
SELECT [Distribution Models].[Distribution Model], [Delivery Locations].[Delivery Location], IIf(IsNull([Entrepreneur Company Programme Years].[Product ID]),IIf(IsNull([Entr, [Entrepreneur Company].[Company Status ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Distribution Models], [Entrepreneur Company], [Qry Get Division Dist Model and Rec Info by Company], [Delivery Locations], [Products], [Qry Get Last Programme Year ID by Company], [Products], [Entrepreneur Company Programme Years]
Qry SubRpt Daily Lead Summary Follow Up All Divisions
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]), [Distribution Models].[Distribution Model], [Delivery Locations].[Delivery Location] FROM [Entrepreneurs], [Delivery Locations], [Distribution Models] WHERE (((Entrepreneurs.[Process Status ID])=1 Or (Entrepreneurs.[Process Status ID])=3
Qry SubRpt Daily Lead Summary Follow Up One Division
Type: Select
SELECT Entrepreneurs.[Division ID], Count(Entrepreneurs.[Entrepreneur ID]), [Distribution Models].[Distribution Model], [Delivery Locations].[Delivery Location] FROM [Entrepreneurs], [Delivery Locations], [Distribution Models] WHERE (((Entrepreneurs.[Process Status ID])=1 Or (Entrepreneurs.[Process Status ID])=3
Qry SubRpt Daily Lead Summary Leads Less Than 48 Hours All Divs
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Process Status ID])=1 Or (Entrepreneurs.[Process Status ID])=3
Qry SubRpt Daily Lead Summary Leads More Than 48 Hours All Divs
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Process Status ID])=1 Or (Entrepreneurs.[Process Status ID])=3
Qry SubRpt Daily Lead Summary New Leads All Divisions
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Date Record Created])=[Forms]![Frm Reports Single Date Divisio
Qry SubRpt Daily Lead Summary New Leads by Lead Type All Divs
Type: Select
SELECT [Lead Types].[Lead Type], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [Lead Types] WHERE (((Entrepreneurs.[Date Record Created])=[Forms]![Frm Reports Single Date Divisio
Qry SubRpt Daily Lead Summary New Leads by Lead Type One Div
Type: Select
SELECT [Lead Types].[Lead Type], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [Lead Types] WHERE (((Entrepreneurs.[Division ID])=Forms![Frm Reports Single Date Division Dialog]!
Qry SubRpt Daily Lead Summary New Leads One Division
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Date Record Created])=Forms![Frm Reports Single Date Division
Qry SubRpt Daily Lead Summary Pipeline All Divisions
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]), [Distribution Models].[Distribution Model], [Delivery Locations].[Delivery Location] FROM [Entrepreneurs], [ProcessStatus], [Delivery Locations], [Distribution Models] WHERE (((ProcessStatus.[Step Number])>=2 And (ProcessStatus.[Step Number])<=7))
Qry SubRpt Daily Lead Summary Pipeline One Division
Type: Select
SELECT Entrepreneurs.[Division ID], Count(Entrepreneurs.[Entrepreneur ID]), [Distribution Models].[Distribution Model], [Delivery Locations].[Delivery Location] FROM [Entrepreneurs], [ProcessStatus], [Delivery Locations], [Distribution Models] WHERE (((ProcessStatus.[Step Number])>=2 And (ProcessStatus.[Step Number])<=7))
Qry SubRpt Daily Lead Summary Raizcorp Possibles All Divs
Type: Select
SELECT vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs.[Distribution Model], vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs.[Delivery Location], IIf(IsNull([Product ID]),IIf(IsNull([Recommended Product ID]),\, Count(vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs.[Entrepreneur Compa FROM [vwPurpleSubRptDailyLeadSummaryRaizcorpPossiblesAllDivs]
Qry SubRpt Daily Lead Summary Uncontacted All Divisions
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Process Status ID])=4) And ((Entrepreneurs.[Date Record Create
Qry SubRpt Daily Lead Summary Uncontacted One Division
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Process Status ID])=4) And ((Entrepreneurs.[Division ID])=Form
Qry SubRpt Daily Lead Summary Uncontacted PnP All Divisions
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Process Status ID])=63) And ((Entrepreneurs.[Date Record Creat
Qry SubRpt Daily Lead Summary Uncontacted PnP One Division
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Process Status ID])=63) And ((Entrepreneurs.[Division ID])=For
Qry SubRpt Entrepreneur Edit History
Type: Select
SELECT [Entrepreneur Edit History].[Entrepreneur ID], [Entrepreneur Edit History].[Modified By], [Entrepreneur Edit History].[Date Modified] FROM [Entrepreneur Edit History]
Qry SubRpt Entrepreneur Edit Status History
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur ID], [Entrepreneur Status History].[Date Status Changed], [Entrepreneur Status History].[Status Modified By], ProcessStatus.Status, ProcessStatus.[Sort Order], [Entrepreneur Status History].[Process Status Notes] FROM [Entrepreneur Status History], [ProcessStatus]
Qry SubRpt Entrepreneur Profile Merge Data
Type: Select
SELECT Entrepreneurs.[Entrepreneur Company ID], Entrepreneurs.[Entrepreneur ID], [First Name] & \, Entrepreneurs.Province, Entrepreneurs.[Recommended BBBEE Pillar], Products.Product FROM [Entrepreneurs], [ProcessStatus], [Products], [Divisions] WHERE (((Entrepreneurs.[Profile Created])=False) AND ((Entrepreneurs.[Division ID])=1)
Qry SubRpt Entrepreneurial Assessment Results List
Type: Select
SELECT IIf([Entrepreneurial Assessment Results]=1,\, [First Name] & \, [Entrepreneur Company].[Company Name], [Delivery Locations].[Delivery Location] FROM [Entrepreneurs], [Entrepreneur Company], [Delivery Locations] WHERE (((Entrepreneurs.[EA Date])>=[Forms]![Frm Reports Date Dialog]![StartDate] And (
Qry SubRpt Entrepreneurial Assessment Results
Type: Select
SELECT IIf([Entrepreneurial Assessment Results]=1,\, Count(Entrepreneurs.[Entrepreneur ID]), [Qry Count Entrepreneurial Assessment Results].[Total Entrepreneurs] FROM [Entrepreneurs], [Qry Count Entrepreneurial Assessment Results] WHERE (((Entrepreneurs.[EA Date])>=[Forms]![Frm Reports Date Dialog]![StartDate] And (
Qry SubRpt Entrepreneurial Assessment Retake Results List
Type: Select
SELECT IIf([EA Retake Results]=1,\, [First Name] & \, [Entrepreneur Company].[Company Name], [Delivery Locations].[Delivery Location] FROM [Entrepreneurs], [Entrepreneur Company], [Delivery Locations] WHERE (((Entrepreneurs.[EA Retake Date])>=[Forms]![Frm Reports Date Dialog]![StartDate
Qry SubRpt Entrepreneurial Assessment Retake Results
Type: Select
SELECT IIf([EA Retake Results]=1,\, Count(Entrepreneurs.[Entrepreneur ID]), [Qry Count Entrepreneurial Assessment Retake Results].[Total Entrepreneurs] FROM [Entrepreneurs], [Qry Count Entrepreneurial Assessment Retake Results] WHERE (((Entrepreneurs.[EA Retake Date])>=[Forms]![Frm Reports Date Dialog]![StartDate
Qry SubRpt EOI Entrepreneur Company
Type: Select
SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Business Address 1], [Entrepreneur Company].[Business Address 2], [Entrepreneur Company].[Business Address 3], [Entrepreneur Company].[Business Postal Code], [Entrepreneur Company].Website, IndustryLookup.Industry, [Entrepreneur Company].[Brief Description of Business], [Entrepreneur Company].[Average Monthly Turnover], [Entrepreneur Company].[Years in Business], [Entrepreneur Company].[Date Business Started], [Entrepreneur Company].[Permanent Employees], [Entrepreneur Company].[Temporary Employees], [Entrepreneur Company].CompanyReg, [Entrepreneur Company].[Enterprise Type], [Entrepreneur Company].[Trading As], [Entrepreneur Company].[BEE Certificate Expire Date], [Entrepreneur Company].[Tax Clearance Expire Date], [Entrepreneur Company].[BEE Level], [Entrepreneur Company].[BEE Certificate Type], [Entrepreneur Company].[Percentage Black Owned], [Entrepreneur Company].[Percentage Women Black Owned], [Entrepreneur Company].[Special Accreditations], [Entrepreneur Company].[Business Premises], [Entrepreneur Company].[Business Premises Other], [Entrepreneur Company].[Monthly Premises Rental], [Entrepreneur Company].[Premises Square Meters], IIf([Equipment Insurance]=True,\, [Entrepreneur Company].[Equipment Insurance Amt], IIf([Personal Vehicle Insurance]=True,\, [Entrepreneur Company].[Personal Vehicle Insurance Amt], IIf([Business Vehicle Insurance]=True,\, [Entrepreneur Company].[Business Vehicle Insurance Amt], IIf([Loss of Earnings Insurance]=True,\, [Entrepreneur Company].[Loss of Earnings Insurance Amt], IIf([Stock Insurance]=True,\, [Entrepreneur Company].[Stock Insurance Amt], IIf([Forex Insurance]=True,\, [Entrepreneur Company].[Forex Insurance Amt], IIf([Life Insurance]=True,\, [Entrepreneur Company].[Life Insurance Amt], IIf([Personal Medical Aid]=True,\, [Entrepreneur Company].[Personal Medical Aid Amt], IIf([Staff Medical Aid]=True,\, [Entrepreneur Company].[Staff Medical Aid Amt], IIf([Other Insurance]=True,\, [Entrepreneur Company].[Other Insurance Amt], [Entrepreneur Company].[Other Insurance Explanation], IIf([Own Bookkeeper]=True,\, [Entrepreneur Company].[Bookkeeper Avg Monthly Cost], [Entrepreneur Company].[Bookkeeper Rating], [Entrepreneur Company].[Bookkeeper Name], [Entrepreneur Company].[Bookkeeper Software], [Entrepreneur Company].[Other Software Explanation] FROM [Entrepreneur Company], [IndustryLookup]
Qry SubRpt Exec Lead Summary Headhunted Single Date All Divs
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Headhunted By]) Is Not Null) And ((Entrepreneurs.[Date Record
Qry SubRpt Exec Lead Summary Headhunted Single Date One Div
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Division ID])=Forms![Frm Reports Single Date Division Dialog]!
Qry SubRpt Lead Delivery Location All Lead Types
Type: Select
SELECT Count([SubQry Count Process Status All Lead Types Criteria].[Entrepreneur ID]), [SubQry Count Process Status All Lead Types Criteria].[Process Status ID], [SubQry Count Process Status All Lead Types Criteria].[Delivery Location] FROM [SubQry Count Process Status All Lead Types Criteria]
Qry SubRpt Lead Delivery Location by Lead Type
Type: Select
SELECT Count([SubQry Count Process Status by Lead Type Criteria].[Entrepreneur ID]), [SubQry Count Process Status by Lead Type Criteria].[Process Status ID], [SubQry Count Process Status by Lead Type Criteria].[Delivery Location] FROM [SubQry Count Process Status by Lead Type Criteria]
Qry SubRpt Lead Delivery Location by Principal Project
Type: Select
SELECT Count([SubQry Count Process Status by Principal Project Criteria].[Entrepreneur , [SubQry Count Process Status by Principal Project Criteria].[Process Status ID], [SubQry Count Process Status by Principal Project Criteria].[Delivery Location] FROM [SubQry Count Process Status by Principal Project Criteria]
Qry SubRpt Lead Process Status All Lead Types
Type: Select
SELECT Count([SubQry Count Process Status All Lead Types Criteria].[Entrepreneur ID]), [SubQry Count Process Status All Lead Types Criteria].[Step Number], [SubQry Count Process Status All Lead Types Criteria].Status, [SubQry Count Process Status All Lead Types Criteria].[Sort Order] FROM [SubQry Count Process Status All Lead Types Criteria]
Qry SubRpt Lead Process Status by Delivery Location
Type: Select
SELECT Count([SubQry Count Process Status by Delivery Location Criteria].[Entrepreneur , [SubQry Count Process Status by Delivery Location Criteria].[Step Number], [SubQry Count Process Status by Delivery Location Criteria].Status, [SubQry Count Process Status by Delivery Location Criteria].[Sort Order] FROM [SubQry Count Process Status by Delivery Location Criteria]
Qry SubRpt Lead Process Status by Lead Type
Type: Select
SELECT Count([SubQry Count Process Status by Lead Type Criteria].[Entrepreneur ID]), [SubQry Count Process Status by Lead Type Criteria].[Step Number], [SubQry Count Process Status by Lead Type Criteria].Status, [SubQry Count Process Status by Lead Type Criteria].[Sort Order] FROM [SubQry Count Process Status by Lead Type Criteria]
Qry SubRpt Lead Process Status by Principal Project
Type: Select
SELECT Count([SubQry Count Process Status by Principal Project Criteria].[Entrepreneur , [SubQry Count Process Status by Principal Project Criteria].[Step Number], [SubQry Count Process Status by Principal Project Criteria].Status, [SubQry Count Process Status by Principal Project Criteria].[Sort Order] FROM [SubQry Count Process Status by Principal Project Criteria]
Qry SubRpt Lead Summary Headhunted Date Range
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Headhunted By]) Is Not Null) And ((Entrepreneurs.[Date Record
Qry SubRpt Lead Summary Referred to Prosperator Date Range
Type: Select
SELECT Count(Entrepreneurs.[Entrepreneur ID]), [Entrepreneur Status History].[Process Status ID], [Delivery Locations].[Delivery Location] FROM [Entrepreneurs], [Entrepreneur Status History], [Delivery Locations] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=[Forms]![Frm Reports Da
Qry SubRpt Lead Unqualified All Lead Types
Type: Select
SELECT Count([SubQry Count Process Status All Lead Types Criteria].[Entrepreneur ID]), [SubQry Count Process Status All Lead Types Criteria].Status, [SubQry Count Process Status All Lead Types Criteria].[Sort Order] FROM [SubQry Count Process Status All Lead Types Criteria] WHERE ((([SubQry Count Process Status All Lead Types Criteria].[Process Status ID])=59
Qry SubRpt Lead Unqualified by Delivery Location
Type: Select
SELECT Count([SubQry Count Process Status by Delivery Location Criteria].[Entrepreneur , [SubQry Count Process Status by Delivery Location Criteria].Status, [SubQry Count Process Status by Delivery Location Criteria].[Sort Order] FROM [SubQry Count Process Status by Delivery Location Criteria] WHERE ((([SubQry Count Process Status by Delivery Location Criteria].[Process Status I
Qry SubRpt Lead Unqualified by Lead Type
Type: Select
SELECT Count([SubQry Count Process Status by Lead Type Criteria].[Entrepreneur ID]), [SubQry Count Process Status by Lead Type Criteria].Status, [SubQry Count Process Status by Lead Type Criteria].[Sort Order] FROM [SubQry Count Process Status by Lead Type Criteria] WHERE ((([SubQry Count Process Status by Lead Type Criteria].[Process Status ID])=59))
Qry SubRpt Lead Unqualified by Principal Project
Type: Select
SELECT Count([SubQry Count Process Status by Principal Project Criteria].[Entrepreneur , [SubQry Count Process Status by Principal Project Criteria].Status, [SubQry Count Process Status by Principal Project Criteria].[Sort Order] FROM [SubQry Count Process Status by Principal Project Criteria] WHERE ((([SubQry Count Process Status by Principal Project Criteria].[Process Status I
Qry SubRpt Lead Unqualified Reason All Lead Types
Type: Select
SELECT Count([SubQry Count Process Status All Lead Types Criteria].[Entrepreneur ID]), [SubQry Count Process Status All Lead Types Criteria].[Process Status ID], [SubQry Count Process Status All Lead Types Criteria].[Unqualified Reason] FROM [SubQry Count Process Status All Lead Types Criteria]
Qry SubRpt Lead Unqualified Reason by Delivery Location
Type: Select
SELECT Count([SubQry Count Process Status by Delivery Location Criteria].[Entrepreneur , [SubQry Count Process Status by Delivery Location Criteria].[Process Status ID], [SubQry Count Process Status by Delivery Location Criteria].[Unqualified Reason] FROM [SubQry Count Process Status by Delivery Location Criteria]
Qry SubRpt Lead Unqualified Reason by Lead Type
Type: Select
SELECT Count([SubQry Count Process Status by Lead Type Criteria].[Entrepreneur ID]), [SubQry Count Process Status by Lead Type Criteria].[Process Status ID], [SubQry Count Process Status by Lead Type Criteria].[Unqualified Reason] FROM [SubQry Count Process Status by Lead Type Criteria]
Qry SubRpt Lead Unqualified Reason by Principal Project
Type: Select
SELECT Count([SubQry Count Process Status by Principal Project Criteria].[Entrepreneur , [SubQry Count Process Status by Principal Project Criteria].[Process Status ID], [SubQry Count Process Status by Principal Project Criteria].[Unqualified Reason] FROM [SubQry Count Process Status by Principal Project Criteria]
Qry SubRpt Pipeline Process Status All Lead Types
Type: Select
SELECT Count([SubQry Count Process Status All Lead Types Criteria].[Entrepreneur ID]), [SubQry Count Process Status All Lead Types Criteria].Status, [SubQry Count Process Status All Lead Types Criteria].[Sort Order] FROM [SubQry Count Process Status All Lead Types Criteria] WHERE ((([SubQry Count Process Status All Lead Types Criteria].[Step Number])>=2 And (
Qry SubRpt Pipeline Process Status by Delivery Location
Type: Select
SELECT Count([SubQry Count Process Status by Delivery Location Criteria].[Entrepreneur , [SubQry Count Process Status by Delivery Location Criteria].Status, [SubQry Count Process Status by Delivery Location Criteria].[Sort Order] FROM [SubQry Count Process Status by Delivery Location Criteria] WHERE ((([SubQry Count Process Status by Delivery Location Criteria].[Step Number])>=2
Qry SubRpt Pipeline Process Status by Lead Type
Type: Select
SELECT Count([SubQry Count Process Status by Lead Type Criteria].[Entrepreneur ID]), [SubQry Count Process Status by Lead Type Criteria].Status, [SubQry Count Process Status by Lead Type Criteria].[Sort Order] FROM [SubQry Count Process Status by Lead Type Criteria] WHERE ((([SubQry Count Process Status by Lead Type Criteria].[Step Number])>=2 And ([S
Qry SubRpt Pipeline Process Status by Principal Project
Type: Select
SELECT Count([SubQry Count Process Status by Principal Project Criteria].[Entrepreneur , [SubQry Count Process Status by Principal Project Criteria].Status, [SubQry Count Process Status by Principal Project Criteria].[Sort Order] FROM [SubQry Count Process Status by Principal Project Criteria] WHERE ((([SubQry Count Process Status by Principal Project Criteria].[Step Number])>=2
Qry SubRpt Pipeline Terminated All Lead Types
Type: Select
SELECT Count([SubQry Count Process Status All Lead Types Criteria].[Entrepreneur ID]), [SubQry Count Process Status All Lead Types Criteria].Status, [SubQry Count Process Status All Lead Types Criteria].[Sort Order] FROM [SubQry Count Process Status All Lead Types Criteria] WHERE ((([SubQry Count Process Status All Lead Types Criteria].[Process Status ID])=41
Qry SubRpt Pipeline Terminated by Delivery Location
Type: Select
SELECT Count([SubQry Count Process Status by Delivery Location Criteria].[Entrepreneur , [SubQry Count Process Status by Delivery Location Criteria].Status, [SubQry Count Process Status by Delivery Location Criteria].[Sort Order] FROM [SubQry Count Process Status by Delivery Location Criteria] WHERE ((([SubQry Count Process Status by Delivery Location Criteria].[Process Status I
Qry SubRpt Pipeline Terminated by Lead Type
Type: Select
SELECT Count([SubQry Count Process Status by Lead Type Criteria].[Entrepreneur ID]), [SubQry Count Process Status by Lead Type Criteria].Status, [SubQry Count Process Status by Lead Type Criteria].[Sort Order] FROM [SubQry Count Process Status by Lead Type Criteria] WHERE ((([SubQry Count Process Status by Lead Type Criteria].[Process Status ID])=41))
Qry SubRpt Pipeline Terminated by Principal Project
Type: Select
SELECT Count([SubQry Count Process Status by Principal Project Criteria].[Entrepreneur , [SubQry Count Process Status by Principal Project Criteria].Status, [SubQry Count Process Status by Principal Project Criteria].[Sort Order] FROM [SubQry Count Process Status by Principal Project Criteria] WHERE ((([SubQry Count Process Status by Principal Project Criteria].[Process Status I
Qry SubRpt Pipeline Termination Reason All Lead Types
Type: Select
SELECT Count([SubQry Count Process Status All Lead Types Criteria].[Entrepreneur ID]), [SubQry Count Process Status All Lead Types Criteria].[Process Status ID], [SubQry Count Process Status All Lead Types Criteria].[Termination Reason] FROM [SubQry Count Process Status All Lead Types Criteria]
Qry SubRpt Pipeline Termination Reason by Delivery Location
Type: Select
SELECT Count([SubQry Count Process Status by Delivery Location Criteria].[Entrepreneur , [SubQry Count Process Status by Delivery Location Criteria].[Process Status ID], [SubQry Count Process Status by Delivery Location Criteria].[Termination Reason] FROM [SubQry Count Process Status by Delivery Location Criteria]
Qry SubRpt Pipeline Termination Reason by Lead Type
Type: Select
SELECT Count([SubQry Count Process Status by Lead Type Criteria].[Entrepreneur ID]), [SubQry Count Process Status by Lead Type Criteria].[Process Status ID], [SubQry Count Process Status by Lead Type Criteria].[Termination Reason] FROM [SubQry Count Process Status by Lead Type Criteria]
Qry SubRpt Pipeline Termination Reason by Principal Project
Type: Select
SELECT Count([SubQry Count Process Status by Principal Project Criteria].[Entrepreneur , [SubQry Count Process Status by Principal Project Criteria].[Process Status ID], [SubQry Count Process Status by Principal Project Criteria].[Termination Reason] FROM [SubQry Count Process Status by Principal Project Criteria]
Qry SubRpt Principal Project Allocation Audit Replaced Companies
Type: Select
SELECT [Principal Projects].[Principal Project ID], CompanyStatus.Status, IIf(IsNull([Programme Year Status]),[Status],[Programme Year Status]), IIf(IsNull([CompanyProgrammeYearStatus].[Sort Order]),0,[CompanyProgrammeYearSta, [Entrepreneur Company Programme Years].[Date Status Changed], [Entrepreneur Company Principal Projects].[Replacement Status], [Entrepreneur Company].[Company Name], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Products], [Entrepreneur Company], [CompanyStatus], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals], [Qry Sum Total Spend by Principal Project], [CompanyProgrammeYearStatus], [Delivery Locations] WHERE ((([Principal Projects].[Principal Project ID])=[Forms]![Frm Principal Report Da
Qry SubRpt Principal Project Pillar Delivery Locations
Type: Select
-- Unable to parse query definition
Qry SubRpt Principal Project Pillars
Type: Select
SELECT [Principal Project Pillars].[Principal Project Pillar ID], [Principal Project Pillars].[Principal Project ID], [Principal Project Pillars].[BBBEE Pillar], [Principal Project Pillars].[Amount Sponsored], [Principal Project Pillars].[Number of Companies Required], IIf([Does Principal Approve Entrepreneurs]=True,\, [Principal Project Pillars].[Entrepreneur Delivery Date] FROM [Principal Project Pillars]
Qry SubRpt Products Sold by Principal Project
Type: Select
SELECT [Principal Project Products Sold].[Principal Project ID], [Principal Project Products Sold].Product FROM [Principal Project Products Sold]
Qry SubRpt Progress Category Mktg by Principal Project
Type: Select
SELECT [SubQry Count Progress Category RM by Principal Project Criteria].[Progress Cate, [SubQry Count Progress Category RM by Principal Project Criteria].[Progress Cate, Count([SubQry Count Progress Category RM by Principal Project Criteria].[Entrepr FROM [SubQry Count Progress Category RM by Principal Project Criteria]
Qry SubRpt Progress Category Sup List by Principal Project
Type: Select
SELECT [SubQry Count Progress Category SL by Principal Project Criteria].[Progress Cate, [SubQry Count Progress Category SL by Principal Project Criteria].[Progress Cate, Count([SubQry Count Progress Category SL by Principal Project Criteria].[Entrepr FROM [SubQry Count Progress Category SL by Principal Project Criteria]
Qry SubRpt Purple Panel Results Date Range
Type: Select
SELECT IIf([PP Results]=1,\, Count(Entrepreneurs.[Entrepreneur ID]), [Qry Count Purple Panel Results Date Range].[Total Entrepreneurs] FROM [Qry Count Purple Panel Results Date Range], [Entrepreneurs] WHERE (((Entrepreneurs.[Date Panel Held])>=[Forms]![Frm Reports Print Export Date Dial
Qry SubRpt Purple Panel Results List Date Range
Type: Select
SELECT IIf([PP Results]=1,\, [Delivery Locations].[Delivery Location], [First Name] & \, [Entrepreneur Company].[Company Name], Entrepreneurs.[Date Panel Held] FROM [Entrepreneurs], [Entrepreneur Company], [Delivery Locations] WHERE (((Entrepreneurs.[Date Panel Held])>=[Forms]![Frm Reports Print Export Date Dial
Qry SubRpt Sponsorship Elements by Principal Project
Type: Select
SELECT vwPurpleSubRptSponsorshipbyPrincipalProject.[Principal Project ID], vwPurpleSubRptSponsorshipbyPrincipalProject.[Company Name], vwPurpleSubRptSponsorshipbyPrincipalProject.[BBBEE Pillar], vwPurpleSubRptSponsorshipbyPrincipalProject.[Element Type], vwPurpleSubRptSponsorshipbyPrincipalProject.[Extra Sponsorship Amount], IIf(IsNull([Total Company Payments]),0,[Total Company Payments]), [Qry Sum Total Sponsor Elements by Principal Project].[Total Sponsor Elements], IIf(IsNull([Total Sponsorship Spend]),0,[Total Sponsorship Spend]), [Total Sponsor Elements]-[Total Spend] FROM [vwPurpleSubRptSponsorshipbyPrincipalProject], [Qry Sum Total Sponsor Elements by Principal Project], [Qry Sum Sponsor Elements Payments by Company], [Qry Sum Total Sponsor Elements Spend by Principal Project] WHERE (((vwPurpleSubRptSponsorshipbyPrincipalProject.[Principal Project ID])=[Forms]![
Qry SubRpt Termination Marketing by Principal Project
Type: Select
SELECT Count(vwPurpleSubRptTerminatedMarketingbyPrincipalProject.[Entrepreneur ID]) FROM [vwPurpleSubRptTerminatedMarketingbyPrincipalProject] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi
Qry SubRpt Termination Reasons Marketing by Principal Project
Type: Select
SELECT vwPurpleSubRptTerminatedReasonsMarketingbyPrincipalProject.[Termination Reason], Count(vwPurpleSubRptTerminatedReasonsMarketingbyPrincipalProject.[Entrepreneur I FROM [vwPurpleSubRptTerminatedReasonsMarketingbyPrincipalProject] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi
Qry SubRpt Termination Reasons Supplier Lst by Principal Project
Type: Select
SELECT vwPurpleSubRptTerminatedReasonsSupplierListbyPrinProj.[Termination Reason], Count(vwPurpleSubRptTerminatedReasonsSupplierListbyPrinProj.[Entrepreneur ID]) FROM [vwPurpleSubRptTerminatedReasonsSupplierListbyPrinProj] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi
Qry SubRpt Termination Supplier List by Principal Project
Type: Select
SELECT Count(vwPurpleSubRptTerminatedSupplierListbyPrincipalProject.[Entrepreneur ID]) FROM [vwPurpleSubRptTerminatedSupplierListbyPrincipalProject] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi
Qry SubRpt Unqualified Marketing by Principal Project
Type: Select
SELECT Count(vwPurpleSubRptUnqualifiedMarketingbyPrincipalProject.[Entrepreneur ID]) FROM [vwPurpleSubRptUnqualifiedMarketingbyPrincipalProject] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi
Qry SubRpt Unqualified Reasons Marketing by Principal Project
Type: Select
SELECT vwPurpleSubRptUnqualifiedReasonsMarketingbyPrincipalProject.[Unqualified Reason], Count(vwPurpleSubRptUnqualifiedReasonsMarketingbyPrincipalProject.[Entrepreneur FROM [vwPurpleSubRptUnqualifiedReasonsMarketingbyPrincipalProject] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi
Qry SubRpt Unqualified Reasons Supplier Lst by Principal Project
Type: Select
SELECT vwPurpleSubRptUnqualifiedReasonsSupplierListbyPrinProj.[Unqualified Reason], Count(vwPurpleSubRptUnqualifiedReasonsSupplierListbyPrinProj.[Entrepreneur ID]) FROM [vwPurpleSubRptUnqualifiedReasonsSupplierListbyPrinProj] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi
Qry SubRpt Unqualified Supplier List by Principal Project
Type: Select
SELECT Count(vwPurpleSubRptUnqualifiedSupplierListbyPrincipalProject.[Entrepreneur ID]) FROM [vwPurpleSubRptUnqualifiedSupplierListbyPrincipalProject] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi
Qry Sum Companies Required by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Sum([Principal Project Pillars].[Number of Companies Required]) FROM [Principal Project Pillars]
Qry Sum Sponsor Elements Payments by Company
Type: Select
SELECT [Entrepreneur Company Extra Sponsor Payments].[Entrepreneur Company Extra Sponso, Sum([Entrepreneur Company Extra Sponsor Payments].[Payment Amount]) FROM [Entrepreneur Company Extra Sponsor Payments]
Qry Sum Total Allocated Amt by Company
Type: Select
SELECT [Entrepreneur Company Principal Projects].[Entrepreneur Company Programme Years , Sum([Entrepreneur Company Principal Projects].[Allocated Amount]), Sum([Entrepreneur Company Principal Projects].[Selection Fee]) FROM [Entrepreneur Company Principal Projects]
Qry Sum Total Replaced Billed to Date by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Sum([Entrepreneur Company Monthly Billings].[Billing Amount]) FROM [Entrepreneur Company Monthly Billings], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars] WHERE ((([Entrepreneur Company].[Company Status ID])=4) AND (([Entrepreneur Company Pr
Qry Sum Total Replaced Selection Fee by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Sum([Entrepreneur Company Principal Projects].[Selection Fee]) FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars] WHERE ((([Entrepreneur Company].[Company Status ID])=4) AND (([Entrepreneur Company Pr
Qry Sum Total Spend by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Sum([Principal Project Pillars].[Amount Sponsored]) FROM [Principal Project Pillars]
Qry Sum Total Sponsor Elements by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Sum([Principal Project Pillar Sponsor Elements].[Sponsorship Amount]) FROM [Principal Project Pillar Sponsor Elements], [Principal Project Pillars]
Qry Sum Total Sponsor Elements Spend by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Sum([Entrepreneur Company Extra Sponsor Elements].[Extra Sponsorship Amount]) FROM [Entrepreneur Company Extra Sponsor Elements], [Principal Project Pillar Sponsor Elements], [Principal Project Pillars]
Qry Sum Total Sponsorship by Principal Project Pillar
Type: Select
SELECT [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], Sum(IIf(IsNull([Allocated Amount]),0,[Allocated Amount])+IIf(IsNull([Selection F FROM [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Principal Projects].[Replacement Status]) Is Null Or ([
Qry Sum Total Sponsorship by Principal Project
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Sum(IIf(IsNull([Allocated Amount]),0,[Allocated Amount])+IIf(IsNull([Selection F FROM [Entrepreneur Company Principal Projects], [Principal Project Pillars] WHERE ((([Entrepreneur Company Principal Projects].[Replacement Status]) Is Null Or ([
Qry User List
Type: Select
SELECT DatabaseUsers.[User ID], DatabaseUsers.Username, DatabaseUsers.Department FROM [DatabaseUsers]
Qry User Module List
Type: Select
SELECT DatabaseUsers.[User ID], DatabaseUsers.Username, DatabaseUsers.Department, [DatabaseUsers Module Permissions].[Module Permission], [DatabaseUsers Module Permissions].LEVEL FROM [DatabaseUsers], [DatabaseUsers Module Permissions] WHERE ((([DatabaseUsers Module Permissions].LEVEL)<>\"Disabled\"))
Qry View Entrepreneur Digital First Meeting
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Digital First Meeting Captured], Entrepreneurs.[Digital State of Business], [First Name] & \, Entrepreneurs.[Digital Fulltime in Business], Entrepreneurs.[Digital More Than One Partner], Entrepreneurs.[Digital More Than One Business], Entrepreneurs.[Digital Bank Account], Entrepreneurs.[Digital Fulltime Employees], Entrepreneurs.[Digital Signed Employee Contracts], Entrepreneurs.[Digital Currently Incubated], Entrepreneurs.[Digital Incubation Type], Entrepreneurs.[Digital Comodities], Entrepreneurs.[Digital Motivation], Entrepreneurs.[Blue Heart Score Calculated] FROM [Entrepreneurs]
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 Count Companies by Principal Project Principal Report
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], [Entrepreneur Company].[Entrepreneur Company ID] FROM [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Principal Projects].[Replacement Status])<>\"Replaced\"
SubQry Count Current Active Companies Total
Type: Select
SELECT Entrepreneurs.[Entrepreneur Company ID] FROM [Entrepreneurs], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Programme Years].[Contract Start Date])<Date()) AND (([
SubQry Count Current Active Entrepreneurs Total
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Company Status ID] FROM [Entrepreneurs], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Programme Years].[Contract Start Date])<Date()) AND (([
SubQry Count Entrepreneurs by Principal Project Principal Report
Type: Select
SELECT [Principal Project Pillars].[Principal Project ID], Entrepreneurs.[Entrepreneur ID] FROM [Entrepreneurs], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company Principal Projects].[Replacement Status])<>\"Replaced\"
SubQry Count EPs With Pipeline Moves Criteria
Type: Select
SELECT Entrepreneurs.OwnedBy, Entrepreneurs.[Entrepreneur ID] FROM [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=[Forms]![Frm Reports Da
SubQry Count EPs With Pipeline Moves Dist Model Criteria
Type: Select
SELECT Entrepreneurs.[Delivery Location ID], Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Distribution Model ID] FROM [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=Forms![Frm Reports Date
SubQry Count First Meeting Setup Criteria
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur Status ID], [Delivery Locations].[Delivery Location], Entrepreneurs.OwnedBy, [Entrepreneur Status History].[Status Modified By], [Entrepreneur Status History].[Date Status Changed], [Entrepreneur Status History].[Process Status ID] FROM [Entrepreneurs], [Entrepreneur Status History], [Delivery Locations] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=Forms![Frm Reports Date
SubQry Count Followed Up Criteria
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur Status ID], [Delivery Locations].[Delivery Location], Entrepreneurs.OwnedBy, [Entrepreneur Status History].[Status Modified By], [Entrepreneur Status History].[Date Status Changed], [Entrepreneur Status History].[Process Status ID] FROM [Entrepreneurs], [Entrepreneur Status History], [Delivery Locations] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=Forms![Frm Reports Date
SubQry Count Headhunted by OwnedBy Date Range Criteria
Type: Select
SELECT Entrepreneurs.[Date Record Created], Entrepreneurs.OwnedBy, Entrepreneurs.[Headhunted By], Entrepreneurs.[Entrepreneur ID], ProcessStatus.[Step Number] FROM [Entrepreneurs], [ProcessStatus] WHERE (((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Selection Team Targets Rep
SubQry Count Meetings Criteria
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur Status ID], Entrepreneurs.OwnedBy, ProcessStatus_1.[Step Number], [Entrepreneur Status History].[Date Status Changed], ProcessStatus.Status, ProcessStatus.[Status Type] FROM [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus], [ProcessStatus] WHERE (((ProcessStatus_1.[Step Number])>=2 And (ProcessStatus_1.[Step Number])<=7) And
SubQry Count Meetings Dist Model Criteria
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur Status ID], Entrepreneurs.[Delivery Location ID], ProcessStatus_1.[Step Number], Entrepreneurs.[Distribution Model ID], [Entrepreneur Status History].[Date Status Changed], ProcessStatus.Status, ProcessStatus.[Status Type] FROM [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus], [ProcessStatus] WHERE (((ProcessStatus_1.[Step Number])>=2 And (ProcessStatus_1.[Step Number])<=7) And
SubQry Count Process Status All Lead Types Criteria
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], Entrepreneurs.[Process Status ID], ProcessStatus.Status, ProcessStatus.[Sort Order], ProcessStatus.[Step Number], Entrepreneurs.[Delivery Location ID], [Delivery Locations].[Delivery Location], UnqualifiedReason.[Unqualified Reason], TerminationReason.[Termination Reason], [Lead Types].[Principal Project ID] FROM [Entrepreneurs], [Lead Types], [ProcessStatus], [TerminationReason], [Delivery Locations], [UnqualifiedReason] WHERE (((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Lead Report Date Dialog]![
SubQry Count Process Status by Delivery Location Criteria
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], Entrepreneurs.[Delivery Location ID], Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], Entrepreneurs.[Process Status ID], ProcessStatus.Status, ProcessStatus.[Sort Order], ProcessStatus.[Step Number], [Delivery Locations].[Delivery Location], UnqualifiedReason.[Unqualified Reason], TerminationReason.[Termination Reason], [Lead Types].[Principal Project ID] FROM [Entrepreneurs], [Lead Types], [ProcessStatus], [TerminationReason], [Delivery Locations], [UnqualifiedReason] WHERE (((Entrepreneurs.[Date Record Created])>=Forms![Frm Lead Report Date Dialog]!Sta
SubQry Count Process Status by Lead Type Criteria
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], Entrepreneurs.[Process Status ID], ProcessStatus.Status, ProcessStatus.[Sort Order], ProcessStatus.[Step Number], Entrepreneurs.[Delivery Location ID], [Delivery Locations].[Delivery Location], UnqualifiedReason.[Unqualified Reason], TerminationReason.[Termination Reason], [Lead Types].[Principal Project ID] FROM [Entrepreneurs], [Lead Types], [ProcessStatus], [Temp Lead Type for Lead Report], [TerminationReason], [Delivery Locations], [UnqualifiedReason] WHERE (((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Lead Report Date Dialog]![
SubQry Count Process Status by Principal Project Criteria
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], Entrepreneurs.[Process Status ID], ProcessStatus.Status, ProcessStatus.[Sort Order], ProcessStatus.[Step Number], Entrepreneurs.[Delivery Location ID], [Delivery Locations].[Delivery Location], UnqualifiedReason.[Unqualified Reason], TerminationReason.[Termination Reason], [Lead Types].[Principal Project ID] FROM [Entrepreneurs], [Lead Types], [ProcessStatus], [Temp Principal Project for Lead Report], [TerminationReason], [Delivery Locations], [UnqualifiedReason] WHERE (((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Lead Report Date Dialog]![
SubQry Count Progress Category RM by Principal Project Criteria
Type: Select
SELECT vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Entrepreneur ID], vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Date Record Created], vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Lead Source], vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Company Name], IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Principal, vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Progress Category], vwPurpleCountProgressCategoryRMbyPrinProjCriteria.[Progress Category Sort], IIf(IsNull([Company Status]),[Process Status],[Company Status]), IIf(IsNull([Company Status]),[Progress Category],[Company Status]), IIf(IsNull([Company Status Sort]),[Progress Category Sort],[Company Status Sort] FROM [vwPurpleCountProgressCategoryRMbyPrinProjCriteria] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi
SubQry Count Progress Category SL by Principal Project Criteria
Type: Select
SELECT vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Entrepreneur ID], vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Date Record Created], vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Lead Source], vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Company Name], IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Principal, IIf(IsNull([Company Status]),[Process Status],[Company Status]), vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Progress Category], vwPurpleCountProgressCategorySLbyPrinProjCriteria.[Progress Category Sort], IIf(IsNull([Company Status]),[Progress Category],[Company Status]), IIf(IsNull([Company Status Sort]),[Progress Category Sort],[Company Status Sort] FROM [vwPurpleCountProgressCategorySLbyPrinProjCriteria] WHERE (((IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Princi
SubQry Count Records Created Criteria
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created] FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Reports Date Dialog]![Star
SubQry Count Records Created Dist Model Criteria
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Delivery Location ID], Entrepreneurs.[Distribution Model ID], Entrepreneurs.[Date Record Created] FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Distribution Model ID])=Forms![Frm Reports Date Distribution M
SubQry Count Step 1 Status Criteria
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], [Entrepreneur Status History].[Date Status Changed], ProcessStatus.[Step Number], ProcessStatus.Status FROM [ProcessStatus], [Entrepreneurs], [Entrepreneur Status History] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=Forms![Frm Reports Date
SubQry Count Step 1 Status Dist Model Criteria
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Delivery Location ID], Entrepreneurs.[Distribution Model ID], [Entrepreneur Status History].[Date Status Changed], ProcessStatus.[Step Number], ProcessStatus.Status FROM [ProcessStatus], [Entrepreneurs], [Entrepreneur Status History] WHERE (((Entrepreneurs.[Distribution Model ID])=Forms![Frm Reports Date Distribution M
SubQry Count Terminations Criteria
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur Status ID], Entrepreneurs.OwnedBy, [Entrepreneur Status History].[Date Status Changed], [Entrepreneur Status History].[Process Status ID] FROM [Entrepreneurs], [Entrepreneur Status History] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=Forms![Frm Reports Date
SubQry Count Terminations Dist Model Criteria
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur Status ID], Entrepreneurs.[Delivery Location ID], Entrepreneurs.[Distribution Model ID], [Entrepreneur Status History].[Date Status Changed], [Entrepreneur Status History].[Process Status ID] FROM [Entrepreneurs], [Entrepreneur Status History] WHERE (((Entrepreneurs.[Distribution Model ID])=Forms![Frm Reports Date Distribution M
SubQry Count Unqualified Criteria
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur Status ID], [Delivery Locations].[Delivery Location], Entrepreneurs.OwnedBy, [Entrepreneur Status History].[Status Modified By], [Entrepreneur Status History].[Date Status Changed], [Entrepreneur Status History].[Process Status ID] FROM [Entrepreneurs], [Entrepreneur Status History], [Delivery Locations] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=Forms![Frm Reports Date
SubQry Count Unqualified Dist Model Criteria
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur Status ID], Entrepreneurs.[Delivery Location ID], Entrepreneurs.[Distribution Model ID], [Entrepreneur Status History].[Date Status Changed], [Entrepreneur Status History].[Process Status ID] FROM [Entrepreneurs], [Entrepreneur Status History] WHERE (((Entrepreneurs.[Distribution Model ID])=Forms![Frm Reports Date Distribution M
SubQry Duplicate Entrepreneurs Alt
Type: Select
SELECT Entrepreneurs.[First Name], Entrepreneurs.[Surname], Entrepreneurs.[Email Address], Entrepreneurs.[EOI Business Name], Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Process Status ID], Entrepreneurs.[Date Status Changed], Entrepreneurs.[Lead Type ID] FROM [Entrepreneurs] WHERE (((Entrepreneurs.[First Name]) In (SELECT [First Name] FROM [Entrepreneurs] As T
SubQry Duplicate Entrepreneurs
Type: Select
SELECT Entrepreneurs.[First Name], Entrepreneurs.Surname, Entrepreneurs.[Telephone Number], Entrepreneurs.[EOI Business Name], Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Process Status ID], Entrepreneurs.[Date Status Changed], Entrepreneurs.[Lead Type ID] FROM [Entrepreneurs] WHERE (((Entrepreneurs.[First Name]) In (SELECT [First Name] FROM [Entrepreneurs] As T
SubQry Export Entrepreneur Information for Contract Mail Merge
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company Principal Projects].[Entrepreneur Company Principal Projec, [Project Name] & \, [Entrepreneur Company Principal Projects].[Allocated Amount], [Entrepreneur Company Principal Projects].[Contract Printed], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Entrepreneurs], [Entrepreneur Company], [Principal Project Pillars], [Principal Projects], [Principals], [Products], [BBBEEPillarLookup], [Delivery Locations], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects]
SubQry Get Entrepreneur Moved Last Week Criteria
Type: Select
SELECT vwPurpleGetEntrepreneursSteps1to7.[Entrepreneur ID], vwPurpleGetEntrepreneursSteps1to7.[Delivery Location ID], vwPurpleGetEntrepreneursSteps1to7.[Delivery Location], ProcessStatus.[Step Number], vwPurpleGetEntrepreneursSteps1to7.[Selection Type], Min([Entrepreneur Status History].[Date Status Changed]) FROM [Entrepreneur Status History], [ProcessStatus], [vwPurpleGetEntrepreneursSteps1to7]
SubQry Get Entrepreneur Moved Last Week
Type: Select
SELECT [SubQry Get Entrepreneur Moved Last Week Criteria].[Entrepreneur ID], [SubQry Get Entrepreneur Moved Last Week Criteria].[Delivery Location ID], [SubQry Get Entrepreneur Moved Last Week Criteria].[Delivery Location], [SubQry Get Entrepreneur Moved Last Week Criteria].[Selection Type] FROM [SubQry Get Entrepreneur Moved Last Week Criteria]
SubQry Get Entrepreneur Steps Date Range Criteria
Type: Select
SELECT ProcessStatus.[Step Number], [Entrepreneur Status History].[Entrepreneur ID] FROM [ProcessStatus], [Entrepreneur Status History] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=[Forms]![Frm Reports Da
SubQry Get Entrepreneur Steps Delivery Location Criteria
Type: Select
-- Unable to parse query definition
SubQry Get Entrepreneur Steps For Summary Criteria
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Date Record Created], Entrepreneurs.[Delivery Location ID], Entrepreneurs.OwnedBy, [Entrepreneur Status History].[Date Status Changed], ProcessStatus.[Step Number], [Entrepreneur Status History].[Process Status ID] FROM [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus] WHERE (((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Reports Date Dialog]![Star
SubQry Get Entrepreneur Steps Lead Type Criteria
Type: Select
SELECT vwPurpleGetEntrepreneurStepsCriteria.[Lead Type ID], vwPurpleGetEntrepreneurStepsCriteria.[Step Number], vwPurpleGetEntrepreneurStepsCriteria.[Pipeline ID], vwPurpleGetEntrepreneurStepsCriteria.[Entrepreneur ID] FROM [vwPurpleGetEntrepreneurStepsCriteria] WHERE (((vwPurpleGetEntrepreneurStepsCriteria.[Lead Type ID])=[Forms]![Frm Step Moveme
SubQry Get Entrepreneur Steps Owned by Criteria
Type: Select
SELECT vwPurpleGetEntrepreneurStepsCriteria.OwnedBy, vwPurpleGetEntrepreneurStepsCriteria.[Step Number], vwPurpleGetEntrepreneurStepsCriteria.[Pipeline ID], vwPurpleGetEntrepreneurStepsCriteria.[Entrepreneur ID] FROM [vwPurpleGetEntrepreneurStepsCriteria] WHERE (((vwPurpleGetEntrepreneurStepsCriteria.OwnedBy)=[Forms]![Frm Step Movement Repo
SubQry Get Entrepreneur Steps Recommended Principal Project Crit
Type: Select
SELECT vwPurpleGetEntrepreneurStepsCriteria.[Recommended Principal Project ID], vwPurpleGetEntrepreneurStepsCriteria.[Step Number], vwPurpleGetEntrepreneurStepsCriteria.[Pipeline ID], vwPurpleGetEntrepreneurStepsCriteria.[Entrepreneur ID] FROM [vwPurpleGetEntrepreneurStepsCriteria] WHERE (((vwPurpleGetEntrepreneurStepsCriteria.[Recommended Principal Project ID])=[For
SubQry Get Entrepreneurs Mod OwnedBy Date Range Crit
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID] FROM [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus] WHERE (((Entrepreneurs.[Pipeline ID])=1) And ((Entrepreneurs.OwnedBy) Is Not Null) And
SubQry Get Entrepreneurs Modified Pipeline Date Range Crit
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur ID], Entrepreneurs.[Pipeline ID], Min([Entrepreneur Status History].[Date Status Changed]) FROM [Entrepreneur Status History], [ProcessStatus], [Entrepreneurs] WHERE (((ProcessStatus.[Step Number])=8))
SubQry Get Entrepreneurs Modified Pipeline Last 6 Months Crit
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur ID], Entrepreneurs.[Pipeline ID], Min([Entrepreneur Status History].[Date Status Changed]) FROM [Entrepreneur Status History], [ProcessStatus], [Entrepreneurs] WHERE (((ProcessStatus.[Step Number])=8))
SubQry Get EPs Modified Pipeline 1 Prin Proj Date Range Crit
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur ID], Entrepreneurs.[Pipeline ID], [Principal Project Pillars].[Principal Project ID], Min([Entrepreneur Status History].[Date Status Changed]) FROM [Entrepreneur Status History], [ProcessStatus], [Entrepreneurs], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars] WHERE (((ProcessStatus.[Step Number])=8))
SubQry Get Last Programme Year for Exited Companies
Type: Select
SELECT [Entrepreneur Company Programme Years].[Entrepreneur Company ID], Max([Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years FROM [Principal Projects], [Principals], [Qry Sum Total Spend by Principal Project], [Entrepreneur Company], [Entrepreneur Company Programme Years] WHERE ((([Entrepreneur Company].[Company Status ID])=4 Or ([Entrepreneur Company].[Com
SubQry Get Moved Last Week to Active PP Allocated Exited
Type: Select
SELECT vwPurpleGetMovedLastWeektoActivePPAllocatedExited.[Entrepreneur Company ID] FROM [vwPurpleGetMovedLastWeektoActivePPAllocatedExited] WHERE (((vwPurpleGetMovedLastWeektoActivePPAllocatedExited.[Date Status Changed])>=Dat
SubQry Get Raizcorp Possibles Position
Type: Select
SELECT [Entrepreneur Company Status History].[Entrepreneur Company ID], Max([Entrepreneur Company Status History].[Entrepreneur Company Status ID]) FROM [SubQry Get Moved Last Week to Active PP Allocated Exited], [Entrepreneur Company Status History] WHERE ((([Entrepreneur Company Status History].[Company Status ID])=2 Or ([Entrepreneu
SubQry Process Status NOT in Pipeline List
Type: Select
SELECT [Pipelines Detail].[Pipeline Detail ID], [Pipelines Detail].[Pipeline ID], [Pipelines Detail].[Process Status ID] FROM [Pipelines Detail] WHERE ((([Pipelines Detail].[Pipeline ID])=[Forms]![Frm Add and Edit Pipeline]![Pipeli
SubQry Rpt Assessment Panel Passes per Scout
Type: Select
SELECT Entrepreneurs.OwnedBy, Entrepreneurs.[EA Date], Entrepreneurs.[Entrepreneurial Assessment Results], Entrepreneurs.[Date Panel Held], Entrepreneurs.[PP Results] FROM [Entrepreneurs] WHERE (((Entrepreneurs.[EA Date])>=[Forms]![Frm Reports Date Dialog]![StartDate] And (
SubQry Rpt Average Days Per Step Count EPs
Type: Select
SELECT [SubQry Rpt Average Days Per Step].[Delivery Location ID], [SubQry Rpt Average Days Per Step].[Delivery Location], [SubQry Rpt Average Days Per Step].OwnedBy, Count([SubQry Rpt Average Days Per Step].[Step 1-2 Days]), Count([SubQry Rpt Average Days Per Step].[Step 2-3 Days]), Count([SubQry Rpt Average Days Per Step].[Step 3-4 Days]), Count([SubQry Rpt Average Days Per Step].[Step 4-5 Days]), Count([SubQry Rpt Average Days Per Step].[Step 5-6 Days]), Count([SubQry Rpt Average Days Per Step].[Step 6-7 Days]), Count([SubQry Rpt Average Days Per Step].[Step 7-8 Days]) FROM [SubQry Rpt Average Days Per Step]
SubQry Rpt Average Days Per Step Get DL and Owner
Type: Select
SELECT [SubQry Rpt Average Days Per Step].[Delivery Location ID], [SubQry Rpt Average Days Per Step].[Delivery Location], [SubQry Rpt Average Days Per Step].OwnedBy FROM [SubQry Rpt Average Days Per Step]
SubQry Rpt Average Days Per Step Sum Days
Type: Select
SELECT [SubQry Rpt Average Days Per Step].[Delivery Location ID], [SubQry Rpt Average Days Per Step].[Delivery Location], [SubQry Rpt Average Days Per Step].OwnedBy, Sum([SubQry Rpt Average Days Per Step].[Step 1-2 Days]), Sum([SubQry Rpt Average Days Per Step].[Step 2-3 Days]), Sum([SubQry Rpt Average Days Per Step].[Step 3-4 Days]), Sum([SubQry Rpt Average Days Per Step].[Step 4-5 Days]), Sum([SubQry Rpt Average Days Per Step].[Step 5-6 Days]), Sum([SubQry Rpt Average Days Per Step].[Step 6-7 Days]), Sum([SubQry Rpt Average Days Per Step].[Step 7-8 Days]) FROM [SubQry Rpt Average Days Per Step]
SubQry Rpt Average Days Per Step
Type: Select
SELECT Entrepreneurs.[Delivery Location ID], [Delivery Locations].[Delivery Location], Entrepreneurs.OwnedBy, [First Name] & \, Entrepreneurs.[Process Status ID], ProcessStatus.Status, Entrepreneurs.[Date Record Created], IIf([Reactivated]=True,\, [Temp Entrepreneur Steps].[Step 1 Last Date], [Temp Entrepreneur Steps].[Step 2 Last Date], [Temp Entrepreneur Steps].[Step 3 Last Date], [Temp Entrepreneur Steps].[Step 4 Last Date], [Temp Entrepreneur Steps].[Step 5 Last Date], [Temp Entrepreneur Steps].[Step 6 Last Date], [Temp Entrepreneur Steps].[Step 7 Last Date], [Temp Entrepreneur Steps].[Step 8 Last Date], [Temp Entrepreneur Steps].[Step 0 Last Date], DateDiff(\, DateDiff(\, DateDiff(\, DateDiff(\, DateDiff(\, DateDiff(\, DateDiff(\ FROM [Entrepreneurs], [Temp Entrepreneur Steps], [Delivery Locations], [ProcessStatus] WHERE (((Entrepreneurs.[Process Status ID])<>59))
SubQry Rpt Average Time Through Pipeline by Delivery Location
Type: Select
SELECT [SubQry Rpt Average Time Through Pipeline Criteria].Pipeline, [SubQry Rpt Average Time Through Pipeline Criteria].[Distribution Model], [SubQry Rpt Average Time Through Pipeline Criteria].[Delivery Location], Count([SubQry Rpt Average Time Through Pipeline Criteria].[Entrepreneur ID]), Sum([SubQry Rpt Average Time Through Pipeline Criteria].[Pipeline Days]) FROM [SubQry Rpt Average Time Through Pipeline Criteria]
SubQry Rpt Average Time Through Pipeline Criteria
Type: Select
SELECT Pipelines.Pipeline, Entrepreneurs.[First Name], Entrepreneurs.Surname, [Temp Entrepreneur Steps].[Entrepreneur ID], [Distribution Models].[Distribution Model], [Delivery Locations].[Delivery Location], DateDiff(\, Month([Step 8 First Date]), [Temp Entrepreneur Steps].[Step 8 First Date], Year([Step 8 First Date]) FROM [Temp Entrepreneur Steps], [Entrepreneurs], [Delivery Locations], [Distribution Models], [Pipelines]
SubQry Rpt Count Entrepreneurs In the Pipeline by Del Loc
Type: Select
SELECT Entrepreneurs.[Delivery Location ID], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus] WHERE (((Entrepreneurs.[Distribution Model ID])=Forms![Frm Reports Date Distribution M
SubQry Rpt Count Entrepreneurs In the Pipeline
Type: Select
SELECT Entrepreneurs.OwnedBy, Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus] WHERE (((ProcessStatus.[Step Number])>=2 And (ProcessStatus.[Step Number])<=7))
SubQry Rpt Count Entrepreneurs With Pipeline Moves by Del Loc
Type: Select
SELECT [SubQry Count EPs With Pipeline Moves Dist Model Criteria].[Delivery Location ID, Count([SubQry Count EPs With Pipeline Moves Dist Model Criteria].[Entrepreneur I FROM [SubQry Count EPs With Pipeline Moves Dist Model Criteria]
SubQry Rpt Count Entrepreneurs With Pipeline Moves
Type: Select
SELECT [SubQry Count EPs With Pipeline Moves Criteria].OwnedBy, Count([SubQry Count EPs With Pipeline Moves Criteria].[Entrepreneur ID]) FROM [SubQry Count EPs With Pipeline Moves Criteria]
SubQry Rpt Count Exited Leads
Type: Select
SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=91) AND (([SubQry
SubQry Rpt Count First Meeting Setup by Modified By
Type: Select
SELECT [SubQry Count First Meeting Setup Criteria].[Delivery Location], [SubQry Count First Meeting Setup Criteria].[Status Modified By], Count([SubQry Count First Meeting Setup Criteria].[Entrepreneur Status ID]) FROM [SubQry Count First Meeting Setup Criteria]
SubQry Rpt Count Followed Up by Modified By
Type: Select
SELECT [SubQry Count Followed Up Criteria].[Delivery Location], [SubQry Count Followed Up Criteria].[Status Modified By], Count([SubQry Count Followed Up Criteria].[Entrepreneur Status ID]) FROM [SubQry Count Followed Up Criteria]
SubQry Rpt Count Followed Up Leads
Type: Select
SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=1))
SubQry Rpt Count Meetings by Del Loc
Type: Select
SELECT [SubQry Count Meetings Dist Model Criteria].[Delivery Location ID], Count([SubQry Count Meetings Dist Model Criteria].[Entrepreneur Status ID]) FROM [SubQry Count Meetings Dist Model Criteria]
SubQry Rpt Count Meetings by Owned By
Type: Select
SELECT [SubQry Count Meetings Criteria].OwnedBy, Count([SubQry Count Meetings Criteria].[Entrepreneur Status ID]) FROM [SubQry Count Meetings Criteria]
SubQry Rpt Count On Hold Leads
Type: Select
SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=64))
SubQry Rpt Count Passed Panel Leads
Type: Select
SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=91))
SubQry Rpt Count Qualified Leads by Date
Type: Select
SELECT [SubQry Rpt Marketing Leads Criteria].[Date Record Created], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Step Number])>=2 And ([SubQry Rpt Mark
SubQry Rpt Count Qualified Leads
Type: Select
SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Step Number])>=2 And ([SubQry Rpt Mark
SubQry Rpt Count Terminated Leads
Type: Select
SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=41))
SubQry Rpt Count Terminations by Del Loc
Type: Select
SELECT [SubQry Count Terminations Dist Model Criteria].[Delivery Location ID], Count([SubQry Count Terminations Dist Model Criteria].[Entrepreneur Status ID]) FROM [SubQry Count Terminations Dist Model Criteria]
SubQry Rpt Count Terminations by Owned By
Type: Select
SELECT [SubQry Count Terminations Criteria].OwnedBy, Count([SubQry Count Terminations Criteria].[Entrepreneur Status ID]) FROM [SubQry Count Terminations Criteria]
SubQry Rpt Count Total Leads Generated by Date
Type: Select
SELECT [SubQry Rpt Marketing Leads Criteria].[Date Record Created], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria]
SubQry Rpt Count Total Leads Generated
Type: Select
SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria]
SubQry Rpt Count Uncontacted Leads
Type: Select
SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=4))
SubQry Rpt Count Unqualified by Del Loc
Type: Select
SELECT [SubQry Count Unqualified Dist Model Criteria].[Delivery Location ID], Count([SubQry Count Unqualified Dist Model Criteria].[Entrepreneur Status ID]) FROM [SubQry Count Unqualified Dist Model Criteria]
SubQry Rpt Count Unqualified by Modified By
Type: Select
SELECT [SubQry Count Unqualified Criteria].[Delivery Location], [SubQry Count Unqualified Criteria].[Status Modified By], Count([SubQry Count Unqualified Criteria].[Entrepreneur Status ID]) FROM [SubQry Count Unqualified Criteria]
SubQry Rpt Count Unqualified by Owned By
Type: Select
SELECT [SubQry Count Unqualified Criteria].OwnedBy, Count([SubQry Count Unqualified Criteria].[Entrepreneur Status ID]) FROM [SubQry Count Unqualified Criteria]
SubQry Rpt Count Unqualified Leads
Type: Select
SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=59))
SubQry Rpt Detailed Movement Date Range Criteria
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur ID], [Entrepreneur Status History].[Date Status Changed] FROM [Entrepreneur Status History] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=[Forms]![Frm Detailed M
SubQry Rpt Detailed Movement Date Range
Type: Select
SELECT [SubQry Rpt Detailed Movement Date Range Criteria].[Entrepreneur ID] FROM [SubQry Rpt Detailed Movement Date Range Criteria]
SubQry Rpt Detailed Movement Owned by Criteria
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur ID], [Entrepreneur Status History].[Date Status Changed], Entrepreneurs.OwnedBy FROM [Entrepreneurs], [Entrepreneur Status History] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=[Forms]![Frm Detailed M
SubQry Rpt Detailed Movement Owned By
Type: Select
SELECT [SubQry Rpt Detailed Movement Owned by Criteria].[Entrepreneur ID] FROM [SubQry Rpt Detailed Movement Owned by Criteria]
SubQry Rpt Detailed Movement Pipeline Date Range Criteria
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur ID], [Entrepreneur Status History].[Date Status Changed], ProcessStatus.[Step Number] FROM [Entrepreneur Status History], [ProcessStatus] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=Forms![Frm Detailed Mov
SubQry Rpt Detailed Movement Pipeline Date Range
Type: Select
SELECT [SubQry Rpt Detailed Movement Pipeline Date Range Criteria].[Entrepreneur ID] FROM [SubQry Rpt Detailed Movement Pipeline Date Range Criteria]
SubQry Rpt Entrepreneurial Profiles
Type: Select
-- Unable to parse query definition
SubQry Rpt Get Modified By
Type: Select
-- Unable to parse query definition
SubQry Rpt Get Owned By
Type: Select
-- Unable to parse query definition
SubQry Rpt Headhunting by Owned By Date Range Criteria
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Headhunted By], Entrepreneurs.[Process Status ID] FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Headhunted By]) Is Not Null) And ((Entrepreneurs.[Date Record
SubQry Rpt Headhunting Count Qualified by Owned By
Type: Select
SELECT [SubQry Rpt Headhunting by Owned By Date Range Criteria].[Headhunted By], Count([SubQry Rpt Headhunting by Owned By Date Range Criteria].[Entrepreneur ID] FROM [SubQry Rpt Headhunting by Owned By Date Range Criteria] WHERE ((([SubQry Rpt Headhunting by Owned By Date Range Criteria].[Process Status ID])
SubQry Rpt Headhunting Count Total by Owned By
Type: Select
SELECT [SubQry Rpt Headhunting by Owned By Date Range Criteria].[Headhunted By], Count([SubQry Rpt Headhunting by Owned By Date Range Criteria].[Entrepreneur ID] FROM [SubQry Rpt Headhunting by Owned By Date Range Criteria]
SubQry Rpt Lead Daily Breakdown Count Passed Panel Leads
Type: Select
SELECT [SubQry Rpt Lead Daily Breakdown Criteria].[Date Record Created], [SubQry Rpt Lead Daily Breakdown Criteria].[Lead Type ID], [SubQry Rpt Lead Daily Breakdown Criteria].[Lead Type], Count([SubQry Rpt Lead Daily Breakdown Criteria].[Entrepreneur ID]), [SubQry Rpt Lead Daily Breakdown Criteria].[Step Number] FROM [SubQry Rpt Lead Daily Breakdown Criteria]
SubQry Rpt Lead Daily Breakdown Count Qualified Leads
Type: Select
SELECT [SubQry Rpt Lead Daily Breakdown Criteria].[Date Record Created], [SubQry Rpt Lead Daily Breakdown Criteria].[Lead Type ID], [SubQry Rpt Lead Daily Breakdown Criteria].[Lead Type], Count([SubQry Rpt Lead Daily Breakdown Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Lead Daily Breakdown Criteria] WHERE ((([SubQry Rpt Lead Daily Breakdown Criteria].[Step Number])>=2 And ([SubQry Rpt
SubQry Rpt Lead Daily Breakdown Count Total Leads
Type: Select
SELECT [SubQry Rpt Lead Daily Breakdown Criteria].[Date Record Created], [SubQry Rpt Lead Daily Breakdown Criteria].[Lead Type ID], [SubQry Rpt Lead Daily Breakdown Criteria].[Lead Type], Count([SubQry Rpt Lead Daily Breakdown Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Lead Daily Breakdown Criteria]
SubQry Rpt Lead Daily Breakdown Criteria
Type: Select
SELECT Entrepreneurs.[Date Record Created], [Lead Types].[Lead Source], Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], Entrepreneurs.[Process Status ID], ProcessStatus.[Step Number], Entrepreneurs.[Entrepreneur ID] FROM [Entrepreneurs], [Lead Types], [ProcessStatus] WHERE (((Entrepreneurs.[Date Record Created])>=Forms![Frm Marketing Lead Report Date D
SubQry Rpt Lead Type to Principal Allocation Criteria
Type: Select
SELECT vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Lead Type Principal Project ID, vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Lead Type], IIf(IsNull([Allocated Principal Project ID]),\, IIf(IsNull([Company Status]),[Process Status],[Company Status]), vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Entrepreneur ID], vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Company Name], [First Name] & \, [Lead Principal] & \, [Allocated Principal] & \ FROM [vwPurpleRptLeadTypetoPrincipalAllocationCriteria] WHERE (((vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Lead Type Principal Project
SubQry Rpt Marketing EOI to Passed Panel Count EOI
Type: Select
SELECT Entrepreneurs.[Lead Type ID], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Temp Lead Type for Lead Report], [Entrepreneurs]
SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel
Type: Select
SELECT Entrepreneurs.[Lead Type ID], Entrepreneurs.[PP Results], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Temp Lead Type for Lead Report], [Entrepreneurs]
SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit
Type: Select
SELECT Entrepreneurs.[Lead Type ID], Entrepreneurs.[Entrepreneur ID] FROM [Temp Lead Type for Lead Report], [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus] WHERE (((ProcessStatus.[Step Number])>=2 And (ProcessStatus.[Step Number])<=7))
SubQry Rpt Marketing EOI to Passed Panel Count Qualified
Type: Select
SELECT [SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit].[Lead Type ID], Count([SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit].[Entrepren FROM [SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit]
SubQry Rpt Marketing Leads Criteria
Type: Select
SELECT Entrepreneurs.[Date Record Created], [Lead Types].[Lead Source], Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], Entrepreneurs.[Process Status ID], ProcessStatus.[Step Number], Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Company Status ID] FROM [Entrepreneurs], [Lead Types], [ProcessStatus], [Entrepreneur Company] WHERE (((Entrepreneurs.[Date Record Created])>=Forms![Frm Marketing Lead Report Date D
SubQry Rpt More Than 3 Follow Ups Count
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur ID], Count([Entrepreneur Status History].[Entrepreneur Status ID]) FROM [Entrepreneur Status History] WHERE ((([Entrepreneur Status History].[Process Status ID])=1) And (([Entrepreneur Sta
SubQry Rpt Opal Prin Proj Summary Comp Required _1 Del Loc
Type: Select
SELECT [Qry Count Delivery Locations Allowed by Principal Project].[Number Del Loc Allo, [Principal Projects].[Principal Project Status ID], [Principal Projects].[Principal Project ID], [Qry Sum Companies Required by Principal Project].[Companies Required] FROM [Principal Projects], [Qry Sum Companies Required by Principal Project], [Qry Count Delivery Locations Allowed by Principal Project] WHERE ((([Qry Count Delivery Locations Allowed by Principal Project].[Number Del Loc A
SubQry Rpt Opal Prin Proj Summary Count Active Comp
Type: Select
SELECT [SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project ID], [SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project], Count([SubQry Rpt Opal Principal Project Summary Criteria].[Entrepreneur Company FROM [SubQry Rpt Opal Principal Project Summary Criteria]
SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc
Type: Select
SELECT [SubQry Rpt Opal Principal Project Summary Criteria].[Company Delivery Location , [SubQry Rpt Opal Principal Project Summary Criteria].[Delivery Location], Count([SubQry Rpt Opal Principal Project Summary Criteria].[Entrepreneur Company, Sum([SubQry Rpt Opal Principal Project Summary Criteria].[Allocated Weight]) FROM [SubQry Rpt Opal Principal Project Summary Criteria]
SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc
Type: Select
SELECT [SubQry Rpt Opal Principal Project Summary Criteria].[Company Delivery Location , [SubQry Rpt Opal Principal Project Summary Criteria].[Delivery Location], Count(Entrepreneurs.[Entrepreneur ID]) FROM [SubQry Rpt Opal Principal Project Summary Criteria], [Entrepreneurs]
SubQry Rpt Opal Principal Project Summary Criteria
Type: Select
SELECT vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Entrepreneur Company ID], vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Distribution Model ID], vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Company Programme Year Status ID, vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Company Delivery Location ID], vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Delivery Location], vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Principal Project ID], [Principal] & \, IIf(IsNull([Total Programme Amount]) Or [Total Programme Amount]=0,0,[Allocated , vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Total Programme Amount], vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Allocated Amount] FROM [vwPurpleRptOpalPrincipalProjectSummaryCriteria]
SubQry Rpt Opal Principal Projects by Industry
Type: Select
SELECT IndustryLookup.Industry, [Principal Projects].[Principal Project ID], [Principal] & \, Sum([Principal Project Pillars].[Number of Companies Required]), [Principal Projects].[Principal Project Status ID] FROM [Principal Projects], [Principals], [IndustryLookup], [Principal Project Pillars]
SubQry Rpt Part Sponsorship
Type: Select
SELECT vwPurpleReportPartSponsorship.[Entrepreneur Company ID], vwPurpleReportPartSponsorship.[Company Programme Year Status ID], vwPurpleReportPartSponsorship.[Programme Year Status], vwPurpleReportPartSponsorship.[Lump Sum Allocation], vwPurpleReportPartSponsorship.[Company Status ID], vwPurpleReportPartSponsorship.[Company Status], vwPurpleReportPartSponsorship.[Date Status Changed], vwPurpleReportPartSponsorship.[Status Modified By], vwPurpleReportPartSponsorship.[Company Delivery Location ID], vwPurpleReportPartSponsorship.[Delivery Location], vwPurpleReportPartSponsorship.[Company Name], vwPurpleReportPartSponsorship.Industry, vwPurpleReportPartSponsorship.[Percentage Black Owned], vwPurpleReportPartSponsorship.[Percentage Women Black Owned], vwPurpleReportPartSponsorship.[Brief Description of Business], vwPurpleReportPartSponsorship.Product, vwPurpleReportPartSponsorship.[Total Programme Amount], vwPurpleReportPartSponsorship.[Total Selection Fee], vwPurpleReportPartSponsorship.[Programme Year] FROM [Qry Sum Total Allocated Amt by Company], [vwPurpleReportPartSponsorship]
SubQry Rpt Percent Dropoff After 1st Meeting Cnt Less Than Step2
Type: Select
SELECT Count([SubQry Rpt Percent Dropoff After 1st Meeting Get Less Than Step2].[Entrep FROM [SubQry Rpt Percent Dropoff After 1st Meeting Get Less Than Step2]
SubQry Rpt Percent Dropoff After 1st Meeting Cnt More Than Step2
Type: Select
SELECT Count([SubQry Rpt Percent Dropoff After 1st Meeting Get More Than Step2].[Entrep FROM [SubQry Rpt Percent Dropoff After 1st Meeting Get More Than Step2]
SubQry Rpt Percent Dropoff After 1st Meeting Count 1st Meeting
Type: Select
SELECT Count([SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs].[Entrep FROM [SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs]
SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs
Type: Select
SELECT [Entrepreneur Status History].[Entrepreneur ID] FROM [Entrepreneur Status History] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=Forms![Frm Reports Date
SubQry Rpt Percent Dropoff After 1st Meeting Get Less Than Step2
Type: Select
SELECT [SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs].[Entrepreneur FROM [SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs], [SubQry Rpt Percent Dropoff After 1st Meeting Get More Than Step2], [Entrepreneurs], [ProcessStatus] WHERE ((([SubQry Rpt Percent Dropoff After 1st Meeting Get More Than Step2].[Entrepren
SubQry Rpt Percent Dropoff After 1st Meeting Get More Than Step2
Type: Select
SELECT Entrepreneurs.[Entrepreneur ID] FROM [SubQry Rpt Percent Dropoff After 1st Meeting Get 1st Meeting EPs], [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus] WHERE (((ProcessStatus.[Step Number])>2))
SubQry Rpt Percent Raizcorp Possibles Moved Last Week
Type: Select
SELECT [Delivery Locations].[Delivery Location ID], [Distribution Models].[Distribution Model], [Delivery Locations].[Delivery Location], IIf(IsNull([Moved Raizcorp Possibles]),0,[Moved Raizcorp Possibles]), IIf(IsNull([Current Raizcorp Possibles]),0,[Current Raizcorp Possibles]), [Current]+[Moved], [Moved]/[Total] FROM [Qry Count Current Raizcorp Possibles by Delivery Location], [Delivery Locations], [Qry Count Raizcorp Possibles Moved Last Week by Delivery Loc], [Distribution Models] WHERE (((IIf(IsNull([Moved Raizcorp Possibles]),0,[Moved Raizcorp Possibles]))<>0)) OR
SubQry Rpt Percentage Moved Last Week Digital
Type: Select
SELECT [Qry Count Entrepreneur Steps 1 to 7 Digital by Delivery Location].[Delivery Loc, [Qry Count Entrepreneur Steps 1 to 7 Digital by Delivery Location].[Distribution, [Qry Count Entrepreneur Steps 1 to 7 Digital by Delivery Location].[Delivery Loc, [Qry Count Entrepreneur Steps 1 to 7 Digital by Delivery Location].[Number Steps, [Qry Count Entrepreneur Moved Last Week Digitalby Delivery Loca].[Entrepreneurs FROM [Qry Count Entrepreneur Steps 1 to 7 Digital by Delivery Location], [Qry Count Entrepreneur Moved Last Week Digitalby Delivery Loca]
SubQry Rpt Percentage Moved Last Week Manual
Type: Select
SELECT [Qry Count Entrepreneur Steps 1 to 7 Manual by Delivery Location].[Delivery Loca, [Qry Count Entrepreneur Steps 1 to 7 Manual by Delivery Location].[Distribution , [Qry Count Entrepreneur Steps 1 to 7 Manual by Delivery Location].[Delivery Loca, [Qry Count Entrepreneur Steps 1 to 7 Manual by Delivery Location].[Number Steps , [Qry Count Entrepreneur Moved Last Week Manuaby Delivery Location].[Entrepreneur FROM [Qry Count Entrepreneur Steps 1 to 7 Manual by Delivery Location], [Qry Count Entrepreneur Moved Last Week Manuaby Delivery Location]
SubQry Rpt Purple Panelists Attended
Type: Select
SELECT [SubQry Rpt Purple Panelists Summary Criteria].[Purple Panelist], [SubQry Rpt Purple Panelists Summary Criteria].Convener, Count([SubQry Rpt Purple Panelists Summary Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Purple Panelists Summary Criteria]
SubQry Rpt Purple Panelists Convened
Type: Select
SELECT [SubQry Rpt Purple Panelists Summary Criteria].[Purple Panelist], [SubQry Rpt Purple Panelists Summary Criteria].Convener, Count([SubQry Rpt Purple Panelists Summary Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Purple Panelists Summary Criteria]
SubQry Rpt Purple Panelists Sum Scores
Type: Select
SELECT [SubQry Rpt Purple Panelists Summary Criteria].[Purple Panelist], Sum([SubQry Rpt Purple Panelists Summary Criteria].[Purple Panelist Score]) FROM [SubQry Rpt Purple Panelists Summary Criteria]
SubQry Rpt Purple Panelists Summary Criteria
Type: Select
SELECT Entrepreneurs.[Date Panel Held], [Entrepreneur Purple Panelists].[Purple Panelist], [Entrepreneur Purple Panelists].Convener, Entrepreneurs.[Entrepreneur ID], [Entrepreneur Purple Panelists].[Purple Panelist Score] FROM [Entrepreneur Purple Panelists], [Entrepreneurs] WHERE (((Entrepreneurs.[Date Panel Held])>=[Forms]![Frm Reports Print Export Date Dial
SubQry Rpt Purple Panelists Summary
Type: Select
-- Unable to parse query definition
SubQry Rpt RAG Criteria
Type: Select
SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Status ID], [Entrepreneur Company Principal Projects].[Replacement Status], [Principal Projects].[Principal Project Status ID], [Principal Project Pillars].[Principal Project Pillar ID], [Principal Project Pillars].[Principal Project ID], [Entrepreneur Company Programme Years].[Total Programme Amount], [Entrepreneur Company Principal Projects].[Allocated Amount], [Entrepreneur Company Principal Projects].[Selection Fee], IIf(IsNull([Allocated Amount]),0,[Allocated Amount])+IIf(IsNull([Selection Fee]) FROM [Principal Projects], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [CompanyStatus], [Qry Count Principal Projects by Company] WHERE ((([Principal Projects].[Principal Project Status ID])=2))
SubQry Rpt Recommended Principal Project Allocation
Type: Select
SELECT IIf(IsNull([Entrepreneur Company].[Company Status ID]),[ProcessStatus].[Status],, [Entrepreneur Company].[Company Status ID], ProcessStatus.[Step Number], IIf(IsNull([Principal Project ID]),[Recommended Principal Project ID],[Principal, [Entrepreneur Company].[Company Name], [Entrepreneur Company Principal Projects].[Allocated Amount], [First Name] & \, IIf(IsNull([Entrepreneur Company Programme Years].[Product ID]),[Recommended Pro FROM [Entrepreneurs], [ProcessStatus], [Principal Project Pillars], [Entrepreneur Company], [CompanyStatus], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company].[Company Status ID])=1 Or ([Entrepreneur Company].[Com
SubQry Rpt Selection Team Activity Summary Criteria
Type: Select
SELECT Entrepreneurs.[Date Record Created], Entrepreneurs.[Delivery Location ID], Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Process Status ID], ProcessStatus.Status, ProcessStatus.[Step Number], Entrepreneurs.[Entrepreneurial Assessment Results], Entrepreneurs.[PP Results], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], CompanyProgrammeYearStatus.[Programme Year Status] FROM [Entrepreneurs], [ProcessStatus], [Entrepreneur Company], [Entrepreneur Company Programme Years], [CompanyProgrammeYearStatus] WHERE (((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Reports Date Dialog]![Star
SubQry Rpt Selection Team Summary Total Graduated Off
Type: Select
SELECT [SubQry Rpt Selection Team Activity Summary Criteria].[Delivery Location ID], Count([SubQry Rpt Selection Team Activity Summary Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Selection Team Activity Summary Criteria] WHERE ((([SubQry Rpt Selection Team Activity Summary Criteria].[Company Programme Year
SubQry Rpt Selection Team Summary Total Leads Generated
Type: Select
SELECT [SubQry Rpt Selection Team Activity Summary Criteria].[Delivery Location ID], Count([SubQry Rpt Selection Team Activity Summary Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Selection Team Activity Summary Criteria]
SubQry Rpt Selection Team Summary Total Non Graduate
Type: Select
SELECT [SubQry Rpt Selection Team Activity Summary Criteria].[Delivery Location ID], Count([SubQry Rpt Selection Team Activity Summary Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Selection Team Activity Summary Criteria] WHERE ((([SubQry Rpt Selection Team Activity Summary Criteria].[Company Programme Year
SubQry Rpt Selection Team Summary Total On Programme
Type: Select
SELECT [SubQry Rpt Selection Team Activity Summary Criteria].[Delivery Location ID], Count([SubQry Rpt Selection Team Activity Summary Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Selection Team Activity Summary Criteria] WHERE ((([SubQry Rpt Selection Team Activity Summary Criteria].[Company Programme Year
SubQry Rpt Selection Team Summary Total Passed Assessment
Type: Select
SELECT [SubQry Rpt Selection Team Activity Summary Criteria].[Delivery Location ID], Count([SubQry Rpt Selection Team Activity Summary Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Selection Team Activity Summary Criteria] WHERE ((([SubQry Rpt Selection Team Activity Summary Criteria].[Entrepreneurial Assess
SubQry Rpt Selection Team Summary Total Passed Panel
Type: Select
SELECT [SubQry Rpt Selection Team Activity Summary Criteria].[Delivery Location ID], Count([SubQry Rpt Selection Team Activity Summary Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Selection Team Activity Summary Criteria] WHERE ((([SubQry Rpt Selection Team Activity Summary Criteria].[PP Results])=1))
SubQry Rpt Selection Team Summary Total Qualified
Type: Select
SELECT [SubQry Rpt Selection Team Activity Summary Criteria].[Delivery Location ID], Count([SubQry Rpt Selection Team Activity Summary Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Selection Team Activity Summary Criteria] WHERE ((([SubQry Rpt Selection Team Activity Summary Criteria].[Process Status ID])<>5
TestQuery
Type: Select
-- Unable to parse query definition