Skip to content

Query: Qry Report Arize First Meeting

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

Tables Referenced

  • Success
  • Products
  • Entrepreneur Company
  • Entrepreneur Arize First Meeting
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Entrepreneur ID]
  • [First Name] & \
  • [Entrepreneur Company].[Company Name]
  • [Entrepreneur Arize First Meeting].[Interviewed By]
  • [Entrepreneur Arize First Meeting].[Date Interviewed]
  • 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]

Where Clause

((([Entrepreneur Arize First Meeting].[Interviewed By]) Is Not Null))

Order By

[First Name] & \

SQL

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))