Skip to content

Query: Qry Report Product Sheet

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

Tables Referenced

  • Products

Columns Selected

  • Products.[Product ID]
  • Product
  • Products.[Date Created]
  • Products.[Product State]
  • Products.[Reference Number]
  • Products.[Version Number]
  • Products.[Product Description]
  • Purpose
  • Products.[Client Pain]
  • Products.[User Pain]
  • Products.[Phase 1 Duration Weeks]
  • Products.[Phase 1 Duration Months]
  • Products.[Phase 1 Duration Years]
  • Products.[Phase 2 Duration Weeks]
  • Products.[Phase 2 Duration Months]
  • Products.[Phase 2 Duration Years]
  • Products.[Phase 3 Duration Weeks]
  • Products.[Phase 3 Duration Months]
  • Products.[Phase 3 Duration Years]
  • [Phase 1 Duration Weeks]+[Phase 2 Duration Weeks]+[Phase 3 Duration Weeks]
  • [Phase 1 Duration Months]+[Phase 2 Duration Months]+[Phase 3 Duration Months]
  • [Phase 1 Duration Years]+[Phase 2 Duration Years]+[Phase 3 Duration Years]
  • Products.[EP Delivery Phase 1 Hours]
  • Products.[EP Delivery Phase 2 Hours]
  • Products.[EP Delivery Phase 3 Hours]
  • Products.[EP Learning Phase 1 Hours]
  • Products.[EP Learning Phase 2 Hours]
  • Products.[EP Learning Phase 3 Hours]
  • Products.[EP Group Guiding Phase 1 Hours]
  • Products.[EP Group Guiding Phase 2 Hours]
  • Products.[EP Group Guiding Phase 3 Hours]
  • Products.[EP Individual Guiding Phase 1 Hours]
  • Products.[EP Individual Guiding Phase 2 Hours]
  • Products.[EP Individual Guiding Phase 3 Hours]
  • Products.[EP Delivery Phase 1 Notional Hours]
  • Products.[EP Delivery Phase 2 Notional Hours]
  • Products.[EP Delivery Phase 3 Notional Hours]
  • Products.[EP Learning Phase 1 Notional Hours]
  • Products.[EP Learning Phase 2 Notional Hours]
  • Products.[EP Learning Phase 3 Notional Hours]
  • Products.[EP Group Guiding Phase 1 Notional Hours]
  • Products.[EP Group Guiding Phase 2 Notional Hours]
  • Products.[EP Group Guiding Phase 3 Notional Hours]
  • Products.[EP Individual Guiding Phase 1 Notional Hours]
  • Products.[EP Individual Guiding Phase 2 Notional Hours]
  • Products.[EP Individual Guiding Phase 3 Notional Hours]
  • Products.[RC Delivery Phase 1 Hours]
  • Products.[RC Delivery Phase 2 Hours]
  • Products.[RC Delivery Phase 3 Hours]
  • Products.[RC Learning Phase 1 Hours]
  • Products.[RC Learning Phase 2 Hours]
  • Products.[RC Learning Phase 3 Hours]
  • Products.[RC Group Guiding Phase 1 Hours]
  • Products.[RC Group Guiding Phase 2 Hours]
  • Products.[RC Group Guiding Phase 3 Hours]
  • Products.[RC Individual Guiding Phase 1 Hours]
  • Products.[RC Individual Guiding Phase 2 Hours]
  • Products.[RC Individual Guiding Phase 3 Hours]
  • Products.[Delivery Susceptibility NA]
  • Products.[Delivery Susceptibility]
  • Products.[Is There a Principal Guarantee]
  • Products.[Principal Guarantee]
  • Products.[Is There a Selection Guarantee]
  • Products.[Selection Guarantee]
  • Products.[Programme Timing]
  • Products.[Scalability of Programme]
  • Products.[Programme Type]
  • Products.[Part Sponsorship Percentage]
  • Products.[Minimum Cohort Size NA]
  • Products.[Minimum Cohort Size]
  • Products.[Maximum Cohort Size NA]
  • Products.[Maximum Cohort Size]
  • Products.[Sales Process]
  • Products.[New Sales Process]
  • IIf([Channel Partners Need Notified]=1,\
  • IIf([Solutions Architects Need Notified]=1,\
  • IIf([Price List Need Updated]=1,\
  • IIf([Create Product Summary]=1,\
  • Products.[Programme Notes NA]
  • Products.[Programme Notes]
  • Products.[Assessment Fee NA]
  • Products.[Assessment Fee Phase 1]
  • Products.[Assessment Fee Phase 2]
  • Products.[Assessment Fee Phase 3]
  • Products.[Find and Filter Fee NA]
  • Products.[Find and Filter Fee Phase 1]
  • Products.[Find and Filter Fee Phase 2]
  • Products.[Find and Filter Fee Phase 3]
  • Products.[Filter Only Fee NA]
  • Products.[Filter Only Fee Phase 1]
  • Products.[Filter Only Fee Phase 2]
  • Products.[Filter Only Fee Phase 3]
  • Products.[Monthly Programme Fee NA]
  • Products.[Monthly Programme Fee Zone A Phase 1]
  • Products.[Monthly Programme Fee Zone A Phase 2]
  • Products.[Monthly Programme Fee Zone A Phase 3]
  • Products.[Monthly Programme Fee Zone B Phase 1]
  • Products.[Monthly Programme Fee Zone B Phase 2]
  • Products.[Monthly Programme Fee Zone B Phase 3]
  • Products.[Monthly Programme Fee Zone C Phase 1]
  • Products.[Monthly Programme Fee Zone C Phase 2]
  • Products.[Monthly Programme Fee Zone C Phase 3]
  • Products.[Stipend NA]
  • Products.[Stipend Phase 1]
  • Products.[Stipend Phase 2]
  • Products.[Stipend Phase 3]
  • Products.[Capital Expenditure NA]
  • Products.[Capital Expenditure Phase 1]
  • Products.[Capital Expenditure Phase 2]
  • Products.[Capital Expenditure Phase 3]
  • Products.[Technical Coordination Fee NA]
  • Products.[Technical Coordination Fee Phase 1]
  • Products.[Technical Coordination Fee Phase 2]
  • Products.[Technical Coordination Fee Phase 3]
  • Products.[Technical Incubation Fee NA]
  • Products.[Technical Incubation Fee Phase 1]
  • Products.[Technical Incubation Fee Phase 2]
  • Products.[Technical Incubation Fee Phase 3]
  • Products.[Other Fee NA]
  • Products.[Other Decription]
  • Products.[Other Phase 1]
  • Products.[Other Phase 2]
  • Products.[Other Phase 3]
  • Products.[Stipend Mgmt Fee Percentage]
  • Products.[Stipend Mgmt Fee Other]
  • IIf([Commitment Duration Min Max Fixed]=1,\
  • Products.[Commitment Duration Min]
  • Products.[Commitment Duration Max]
  • Products.[Commitment Duration Fixed]
  • IIf([Stipend Based on EP Compliance]=1,\
  • IIf([Stipend Remains Constant]=1,\
  • Products.[Stipend Payable Amounts]
  • Products.[Why Name Choosen]
  • Products.[Target Market]
  • Products.[Who Will Be Using]
  • Products.[Big Promise]
  • Products.[Compelling to Buy]
  • Products.[Ideal Tagline]
  • Products.[Tagline Dovetail]
  • Products.[First Top Competitor]
  • Products.[Second Top Competitor]
  • Products.[Third Top Competitor]
  • Products.[Product USP]
  • IIf([Done the Research]=1,\
  • Products.[Market Positioning]
  • IIf([Conduct a Survey Principal]=1,\
  • Products.[The Principal Survey]
  • IIf([Conduct a Survey Customer]=1,\
  • Products.[The Customer Survey]
  • Products.[Specialised Graphics Notes]
  • Products.[Specialised Application Form Notes]
  • IIf([Phased Selection]=1,\
  • Products.[Selection Phase 1]
  • IIf([Selection Phase 1]=True,\
  • Products.[Selection Phase 2]
  • IIf([Selection Phase 2]=True,\
  • Products.[Selection Phase 3]
  • IIf([Selection Phase 3]=True,\
  • IIf([Must Overall Percentage]=1,\
  • Products.[Overall Percentage]
  • Products.[Average Gate]
  • Products.[Purple Panel Rubric]
  • Products.[Base Rubric NA]
  • Products.[Base Rubric]
  • Products.[Other Metrics NA]
  • Products.[Other Metrics]
  • Products.[Additional Notes NA]
  • Products.[Additional Notes]
  • Products.[Case Study]
  • Products.[Ignition Session Month Phase 1]
  • Products.[Ignition Session Duration Phase 1]
  • Products.[Ignition Session Month Phase 2]
  • Products.[Ignition Session Duration Phase 2]
  • Products.[Ignition Session Month Phase 3]
  • Products.[Ignition Session Duration Phase 3]
  • Products.[Ignition Box Standard Items Phase 1]
  • Products.[Ignition Box Standard Items Phase 2]
  • Products.[Ignition Box Standard Items Phase 3]
  • IIf([Principal Attend Ignition]=1,\
  • Products.[Who Must Attend]
  • Products.[Ignition Date Communicate]
  • Products.[Ignition Date Communicate Other]
  • Products.[Learning Considerations]
  • Products.[Catering Options Other]
  • Products.[Guiding Considerations]
  • IIf([Standard GPS Template Phase 1]=1,\
  • Products.[Standard GPS Template Specify Phase 1]
  • IIf([Standard GPS Template Phase 2]=1,\
  • Products.[Standard GPS Template Specify Phase 2]
  • IIf([Standard GPS Template Phase 3]=1,\
  • Products.[Standard GPS Template Specify Phase 3]
  • Products.[Additions to Include]
  • IIf([Are Group Indigos Permitted]=1,\
  • Products.[Product Considerations]
  • IIf([Are SD Interventions Required]=1,\
  • IIf([Funding Available]=1,\
  • Products.[Funding Session]
  • Products.[Funding Session Other]
  • IIf([Bookkeeping Available]=1,\
  • Products.[Bookkeeping Services]
  • Products.[Bookkeeping Transactions]
  • Products.[Other Bookkeeping Transactions]
  • Products.[Bookkeeping Service Provider]
  • Products.[Bookkeeping Service Provider Two]
  • Products.[Who Is Principal]
  • Products.[Frequency of Reporting]
  • Products.[Principal Specified Reports]
  • Products.[Additional Terms]
  • Products.[Additional Format Detail]
  • Products.[Product Specific Efficacy Data Other]
  • Products.[Managed By Other]
  • Products.[Saphire Week 1]
  • Products.[Saphire Week 2]
  • Products.[Saphire Week 3]
  • Products.[Saphire Week 4]
  • Products.[Amber Week 1]
  • Products.[Amber Week 2]
  • Products.[Amber Week 3]
  • Products.[Amber Week 4]
  • Products.[Training Process]
  • Products.[New Training Process]

Where Clause

(((Products.[Product ID])=[Forms]![Frm Product List]![ProductList]))

SQL

SELECT Products.[Product ID], Products.Product, Products.[Date Created], Products.[Product State], Products.[Reference Number], Products.[Version Number], Products.[Product Description], Products.Purpose, Products.[Client Pain], Products.[User Pain], Products.[Phase 1 Duration Weeks], Products.[Phase 1 Duration Months], Products.[Phase 1 Duration Years], Products.[Phase 2 Duration Weeks], Products.[Phase 2 Duration Months], Products.[Phase 2 Duration Years], Products.[Phase 3 Duration Weeks], Products.[Phase 3 Duration Months], Products.[Phase 3 Duration Years], [Phase 1 Duration Weeks]+[Phase 2 Duration Weeks]+[Phase 3 Duration Weeks], [Phase 1 Duration Months]+[Phase 2 Duration Months]+[Phase 3 Duration Months], [Phase 1 Duration Years]+[Phase 2 Duration Years]+[Phase 3 Duration Years], Products.[EP Delivery Phase 1 Hours], Products.[EP Delivery Phase 2 Hours], Products.[EP Delivery Phase 3 Hours], Products.[EP Learning Phase 1 Hours], Products.[EP Learning Phase 2 Hours], Products.[EP Learning Phase 3 Hours], Products.[EP Group Guiding Phase 1 Hours], Products.[EP Group Guiding Phase 2 Hours], Products.[EP Group Guiding Phase 3 Hours], Products.[EP Individual Guiding Phase 1 Hours], Products.[EP Individual Guiding Phase 2 Hours], Products.[EP Individual Guiding Phase 3 Hours], Products.[EP Delivery Phase 1 Notional Hours], Products.[EP Delivery Phase 2 Notional Hours], Products.[EP Delivery Phase 3 Notional Hours], Products.[EP Learning Phase 1 Notional Hours], Products.[EP Learning Phase 2 Notional Hours], Products.[EP Learning Phase 3 Notional Hours], Products.[EP Group Guiding Phase 1 Notional Hours], Products.[EP Group Guiding Phase 2 Notional Hours], Products.[EP Group Guiding Phase 3 Notional Hours], Products.[EP Individual Guiding Phase 1 Notional Hours], Products.[EP Individual Guiding Phase 2 Notional Hours], Products.[EP Individual Guiding Phase 3 Notional Hours], Products.[RC Delivery Phase 1 Hours], Products.[RC Delivery Phase 2 Hours], Products.[RC Delivery Phase 3 Hours], Products.[RC Learning Phase 1 Hours], Products.[RC Learning Phase 2 Hours], Products.[RC Learning Phase 3 Hours], Products.[RC Group Guiding Phase 1 Hours], Products.[RC Group Guiding Phase 2 Hours], Products.[RC Group Guiding Phase 3 Hours], Products.[RC Individual Guiding Phase 1 Hours], Products.[RC Individual Guiding Phase 2 Hours], Products.[RC Individual Guiding Phase 3 Hours], Products.[Delivery Susceptibility NA], Products.[Delivery Susceptibility], Products.[Is There a Principal Guarantee], Products.[Principal Guarantee], Products.[Is There a Selection Guarantee], Products.[Selection Guarantee], Products.[Programme Timing], Products.[Scalability of Programme], Products.[Programme Type], Products.[Part Sponsorship Percentage], Products.[Minimum Cohort Size NA], Products.[Minimum Cohort Size], Products.[Maximum Cohort Size NA], Products.[Maximum Cohort Size], Products.[Sales Process], Products.[New Sales Process], IIf([Channel Partners Need Notified]=1,\, IIf([Solutions Architects Need Notified]=1,\, IIf([Price List Need Updated]=1,\, IIf([Create Product Summary]=1,\, Products.[Programme Notes NA], Products.[Programme Notes], Products.[Assessment Fee NA], Products.[Assessment Fee Phase 1], Products.[Assessment Fee Phase 2], Products.[Assessment Fee Phase 3], Products.[Find and Filter Fee NA], Products.[Find and Filter Fee Phase 1], Products.[Find and Filter Fee Phase 2], Products.[Find and Filter Fee Phase 3], Products.[Filter Only Fee NA], Products.[Filter Only Fee Phase 1], Products.[Filter Only Fee Phase 2], Products.[Filter Only Fee Phase 3], Products.[Monthly Programme Fee NA], Products.[Monthly Programme Fee Zone A Phase 1], Products.[Monthly Programme Fee Zone A Phase 2], Products.[Monthly Programme Fee Zone A Phase 3], Products.[Monthly Programme Fee Zone B Phase 1], Products.[Monthly Programme Fee Zone B Phase 2], Products.[Monthly Programme Fee Zone B Phase 3], Products.[Monthly Programme Fee Zone C Phase 1], Products.[Monthly Programme Fee Zone C Phase 2], Products.[Monthly Programme Fee Zone C Phase 3], Products.[Stipend NA], Products.[Stipend Phase 1], Products.[Stipend Phase 2], Products.[Stipend Phase 3], Products.[Capital Expenditure NA], Products.[Capital Expenditure Phase 1], Products.[Capital Expenditure Phase 2], Products.[Capital Expenditure Phase 3], Products.[Technical Coordination Fee NA], Products.[Technical Coordination Fee Phase 1], Products.[Technical Coordination Fee Phase 2], Products.[Technical Coordination Fee Phase 3], Products.[Technical Incubation Fee NA], Products.[Technical Incubation Fee Phase 1], Products.[Technical Incubation Fee Phase 2], Products.[Technical Incubation Fee Phase 3], Products.[Other Fee NA], Products.[Other Decription], Products.[Other Phase 1], Products.[Other Phase 2], Products.[Other Phase 3], Products.[Stipend Mgmt Fee Percentage], Products.[Stipend Mgmt Fee Other], IIf([Commitment Duration Min Max Fixed]=1,\, Products.[Commitment Duration Min], Products.[Commitment Duration Max], Products.[Commitment Duration Fixed], IIf([Stipend Based on EP Compliance]=1,\, IIf([Stipend Remains Constant]=1,\, Products.[Stipend Payable Amounts], Products.[Why Name Choosen], Products.[Target Market], Products.[Who Will Be Using], Products.[Big Promise], Products.[Compelling to Buy], Products.[Ideal Tagline], Products.[Tagline Dovetail], Products.[First Top Competitor], Products.[Second Top Competitor], Products.[Third Top Competitor], Products.[Product USP], IIf([Done the Research]=1,\, Products.[Market Positioning], IIf([Conduct a Survey Principal]=1,\, Products.[The Principal Survey], IIf([Conduct a Survey Customer]=1,\, Products.[The Customer Survey], Products.[Specialised Graphics Notes], Products.[Specialised Application Form Notes], IIf([Phased Selection]=1,\, Products.[Selection Phase 1], IIf([Selection Phase 1]=True,\, Products.[Selection Phase 2], IIf([Selection Phase 2]=True,\, Products.[Selection Phase 3], IIf([Selection Phase 3]=True,\, IIf([Must Overall Percentage]=1,\, Products.[Overall Percentage], Products.[Average Gate], Products.[Purple Panel Rubric], Products.[Base Rubric NA], Products.[Base Rubric], Products.[Other Metrics NA], Products.[Other Metrics], Products.[Additional Notes NA], Products.[Additional Notes], Products.[Case Study], Products.[Ignition Session Month Phase 1], Products.[Ignition Session Duration Phase 1], Products.[Ignition Session Month Phase 2], Products.[Ignition Session Duration Phase 2], Products.[Ignition Session Month Phase 3], Products.[Ignition Session Duration Phase 3], Products.[Ignition Box Standard Items Phase 1], Products.[Ignition Box Standard Items Phase 2], Products.[Ignition Box Standard Items Phase 3], IIf([Principal Attend Ignition]=1,\, Products.[Who Must Attend], Products.[Ignition Date Communicate], Products.[Ignition Date Communicate Other], Products.[Learning Considerations], Products.[Catering Options Other], Products.[Guiding Considerations], IIf([Standard GPS Template Phase 1]=1,\, Products.[Standard GPS Template Specify Phase 1], IIf([Standard GPS Template Phase 2]=1,\, Products.[Standard GPS Template Specify Phase 2], IIf([Standard GPS Template Phase 3]=1,\, Products.[Standard GPS Template Specify Phase 3], Products.[Additions to Include], IIf([Are Group Indigos Permitted]=1,\, Products.[Product Considerations], IIf([Are SD Interventions Required]=1,\, IIf([Funding Available]=1,\, Products.[Funding Session], Products.[Funding Session Other], IIf([Bookkeeping Available]=1,\, Products.[Bookkeeping Services], Products.[Bookkeeping Transactions], Products.[Other Bookkeeping Transactions], Products.[Bookkeeping Service Provider], Products.[Bookkeeping Service Provider Two], Products.[Who Is Principal], Products.[Frequency of Reporting], Products.[Principal Specified Reports], Products.[Additional Terms], Products.[Additional Format Detail], Products.[Product Specific Efficacy Data Other], Products.[Managed By Other], Products.[Saphire Week 1], Products.[Saphire Week 2], Products.[Saphire Week 3], Products.[Saphire Week 4], Products.[Amber Week 1], Products.[Amber Week 2], Products.[Amber Week 3], Products.[Amber Week 4], Products.[Training Process], Products.[New Training Process] FROM [Products] WHERE (((Products.[Product ID])=[Forms]![Frm Product List]![ProductList]))