Skip to content

Query: Qry Report Principal Projects Purchased ED vs SD S2S

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

Tables Referenced

  • Qry Count Number SD Allocated by Principal Project Pillar
  • SubQry Purchased ED vs SD Report S2S
  • Qry Count Number ED Allocated by Principal Project Pillar
  • by
  • Qry Count ED or SD Companies Bought From by Principal Project
  • SubQry
  • Qry Sum ED or SD Amount Purchased by Principal Project

Columns Selected

  • [SubQry Purchased ED vs SD Report S2S].[Principal Project ID]
  • [SubQry Purchased ED vs SD Report S2S].[Client Tier]
  • [SubQry Purchased ED vs SD Report S2S].[Principal Project]
  • FYE
  • IIf(IsNull([Number ED Allocated]),0,[Number ED Allocated])
  • IIf(IsNull([Number SD Allocated]),0,[Number SD Allocated])
  • IIf(IsNull([Number Companies Bought From]),0,[Number Companies Bought From])
  • IIf(IsNull([Total Purchased]),0,[Total Purchased])

Order By

[SubQry Purchased ED vs SD Report S2S].[Client Tier], [SubQry Purchased ED vs SD Report S2S].[Principal Project]

SQL

SELECT [SubQry Purchased ED vs SD Report S2S].[Principal Project ID], [SubQry Purchased ED vs SD Report S2S].[Client Tier], [SubQry Purchased ED vs SD Report S2S].[Principal Project], [SubQry Purchased ED vs SD Report S2S].FYE, IIf(IsNull([Number ED Allocated]),0,[Number ED Allocated]), IIf(IsNull([Number SD Allocated]),0,[Number SD Allocated]), IIf(IsNull([Number Companies Bought From]),0,[Number Companies Bought From]), IIf(IsNull([Total Purchased]),0,[Total Purchased]) FROM [SubQry Purchased ED vs SD Report S2S], [Qry Count Number ED Allocated by Principal Project Pillar], [Qry Sum ED or SD Amount Purchased by Principal Project], [Qry Count Number SD Allocated by Principal Project Pillar], [Qry Count ED or SD Companies Bought From by Principal Project]