Skip to content

Query: Qry SubRpt Product Supplier Development Phase 1

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

Tables Referenced

  • Supplier Development
  • Product
  • Product Supplier Development

Columns Selected

  • [Product Supplier Development].[Product ID]
  • [Product Supplier Development].[Phase Number]
  • [Supplier Development].[Session Type]
  • [Supplier Development].[Session Name]
  • [Supplier Development].[Sort Order]
  • [Product Supplier Development].[Supplier Development Hours]
  • 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 Supplier Development].[Phase Number])=1))

SQL

SELECT [Product Supplier Development].[Product ID], [Product Supplier Development].[Phase Number], [Supplier Development].[Session Type], [Supplier Development].[Session Name], [Supplier Development].[Sort Order], [Product Supplier Development].[Supplier Development Hours], 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 Supplier Development], [Supplier Development] WHERE ((([Product Supplier Development].[Phase Number])=1))