Skip to content

Query: Qry SubRpt Product Guiding Management Phase 1

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

Tables Referenced

  • Guide Management
  • Guide
  • Product Guide Management

Columns Selected

  • [Product Guide Management].[Product ID]
  • [Product Guide Management].[Phase Number]
  • [Guide Management].[Session Type]
  • [Guide Management].[Session Name]
  • [Guide Management].[Sort Order]
  • [Product Guide Management].[Number of Sessions]
  • [Product Guide Management].[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 Guide Management].[Phase Number])=1))

SQL

SELECT [Product Guide Management].[Product ID], [Product Guide Management].[Phase Number], [Guide Management].[Session Type], [Guide Management].[Session Name], [Guide Management].[Sort Order], [Product Guide Management].[Number of Sessions], [Product Guide Management].[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 [Guide Management], [Product Guide Management] WHERE ((([Product Guide Management].[Phase Number])=1))