Skip to content

Query: Qry Report Percent Dropoff After 1st Meeting

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

Tables Referenced

  • SubQry Rpt Percent Dropoff After 1st Meeting Cnt Less Than Step2
  • SubQry
  • SubQry Rpt Percent Dropoff After 1st Meeting Cnt More Than Step2
  • SubQry Rpt Percent Dropoff After 1st Meeting Count 1st Meeting

Columns Selected

  • [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

SQL

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]