Skip to content

Query: Qry Report Opal Principal Project Sum Comp Required 1 Del Loc

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

Tables Referenced

  • Qry Get Delivery Locations Allowed by Principal Project
  • Qry Count Delivery Locations Allowed by Principal Project
  • Principal Projects
  • Qry Sum Companies Required by Principal Project
  • Principal

Columns Selected

  • [Qry Get Delivery Locations Allowed by Principal Project].[Delivery Location]
  • Sum([Qry Sum Companies Required by Principal Project].[Companies Required])
  • [Qry Count Delivery Locations Allowed by Principal Project].[Number Del Loc Allo

Where Clause

((([Principal Projects].[Principal Project Status ID])=2))

SQL

SELECT [Qry Get Delivery Locations Allowed by Principal Project].[Delivery Location], Sum([Qry Sum Companies Required by Principal Project].[Companies Required]), [Qry Count Delivery Locations Allowed by Principal Project].[Number Del Loc Allo FROM [Principal Projects], [Qry Sum Companies Required by Principal Project], [Qry Count Delivery Locations Allowed by Principal Project], [Qry Get Delivery Locations Allowed by Principal Project] WHERE ((([Principal Projects].[Principal Project Status ID])=2))