Skip to content

Query: Qry Report Principal Quarterly Reports

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

Tables Referenced

  • vwGarnetRptPrincipalQuarterlyReports

Columns Selected

  • vwGarnetRptPrincipalQuarterlyReports.[Principal Project ID]
  • vwGarnetRptPrincipalQuarterlyReports.[Process Status ID]
  • vwGarnetRptPrincipalQuarterlyReports.[Division ID]
  • vwGarnetRptPrincipalQuarterlyReports.[Principal Project ID]
  • [Principal] & \

Where Clause

(((vwGarnetRptPrincipalQuarterlyReports.[Principal Project ID]) Is Not Null) AND

Order By

[Principal] & \

SQL

SELECT vwGarnetRptPrincipalQuarterlyReports.[Principal Project ID], vwGarnetRptPrincipalQuarterlyReports.[Process Status ID], vwGarnetRptPrincipalQuarterlyReports.[Division ID], vwGarnetRptPrincipalQuarterlyReports.[Principal Project ID], [Principal] & \ FROM [vwGarnetRptPrincipalQuarterlyReports] WHERE (((vwGarnetRptPrincipalQuarterlyReports.[Principal Project ID]) Is Not Null) AND