Skip to content

Query: Qry Report Opal Principal Project Companies Required

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

Tables Referenced

  • Qry Get Delivery Locations Allowed by Principal Project
  • Principal Projects
  • Qry Sum Companies Required by Principal Project
  • Principals
  • SubQry Rpt Opal Prin Proj Summary Count Active Comp

Columns Selected

  • [Principal Projects].[Principal Project Status ID]
  • [Principal] & \
  • [Qry Sum Companies Required by Principal Project].[Companies Required]
  • IIf(IsNull([Number of Companies]),0,[Number of Companies])
  • IIf(([Companies Required]-[Number Active])<0,0,[Companies Required]-[Number Acti
  • [Qry Get Delivery Locations Allowed by Principal Project].[Delivery Location]

Where Clause

((([Principal Projects].[Principal Project Status ID])=2) AND (([Qry Get Deliver

Order By

[Principal] & \, [Qry Get Delivery Locations Allowed by Principal Project].[Delivery Location]

SQL

SELECT [Principal Projects].[Principal Project Status ID], [Principal] & \, [Qry Sum Companies Required by Principal Project].[Companies Required], IIf(IsNull([Number of Companies]),0,[Number of Companies]), IIf(([Companies Required]-[Number Active])<0,0,[Companies Required]-[Number Acti, [Qry Get Delivery Locations Allowed by Principal Project].[Delivery Location] FROM [Principals], [Principal Projects], [Qry Get Delivery Locations Allowed by Principal Project], [Qry Sum Companies Required by Principal Project], [SubQry Rpt Opal Prin Proj Summary Count Active Comp] WHERE ((([Principal Projects].[Principal Project Status ID])=2) AND (([Qry Get Deliver