Skip to content

Query: Qry SubRpt Product Learning Sessions Phase 2

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

Tables Referenced

  • Learning Sessions
  • Product
  • Product Learning Sessions

Columns Selected

  • [Product Learning Sessions].[Product Learning Session ID]
  • [Product Learning Sessions].[Product ID]
  • [Product Learning Sessions].[Phase Number]
  • [Learning Sessions].[Session Type]
  • [Learning Sessions].[Session Name]
  • [Learning Sessions].[Sort Order]
  • [Product Learning Sessions].[Number of Sessions]
  • [Product Learning 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,\
  • IIf([Catering]=True,\

Where Clause

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

SQL

SELECT [Product Learning Sessions].[Product Learning Session ID], [Product Learning Sessions].[Product ID], [Product Learning Sessions].[Phase Number], [Learning Sessions].[Session Type], [Learning Sessions].[Session Name], [Learning Sessions].[Sort Order], [Product Learning Sessions].[Number of Sessions], [Product Learning 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,\, IIf([Catering]=True,\ FROM [Product Learning Sessions], [Learning Sessions] WHERE ((([Product Learning Sessions].[Phase Number])=2))