Skip to content

Query: Qry SubRpt Product Guiding Sessions Phase 2

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

Tables Referenced

  • Product
  • Guiding Sessions
  • Product Guiding Sessions

Columns Selected

  • [Product Guiding Sessions].[Product ID]
  • [Product Guiding Sessions].[Phase Number]
  • [Guiding Sessions].[Session Type]
  • [Guiding Sessions].[Session Name]
  • [Guiding Sessions].[Sort Order]
  • [Product Guiding Sessions].[Number of Sessions]
  • [Product Guiding Sessions].[Hours per Session]
  • IIf([Month 1]=True,\
  • IIf([Month 2]=True,\
  • IIf([Month 3]=True,\
  • IIf([Month 4]=True,\
  • IIf([Month 5]=True,\
  • IIf([Month 6]=True,\
  • IIf([Month 7]=True,\
  • IIf([Month 8]=True,\
  • IIf([Month 9]=True,\
  • IIf([Month 10]=True,\
  • IIf([Month 11]=True,\
  • IIf([Month 12]=True,\

Where Clause

((([Product Guiding Sessions].[Phase Number])=2))

SQL

SELECT [Product Guiding Sessions].[Product ID], [Product Guiding Sessions].[Phase Number], [Guiding Sessions].[Session Type], [Guiding Sessions].[Session Name], [Guiding Sessions].[Sort Order], [Product Guiding Sessions].[Number of Sessions], [Product Guiding Sessions].[Hours per Session], IIf([Month 1]=True,\, IIf([Month 2]=True,\, IIf([Month 3]=True,\, IIf([Month 4]=True,\, IIf([Month 5]=True,\, IIf([Month 6]=True,\, IIf([Month 7]=True,\, IIf([Month 8]=True,\, IIf([Month 9]=True,\, IIf([Month 10]=True,\, IIf([Month 11]=True,\, IIf([Month 12]=True,\ FROM [Product Guiding Sessions], [Guiding Sessions] WHERE ((([Product Guiding Sessions].[Phase Number])=2))