Skip to content

Query: Qry Report Opal Raizcorpossibles and Part Sponsorship

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

Tables Referenced

  • Qry Get Del Loc Raizcorpossibles Part Sponsorship
  • Qry Count Current Part Sponsorship by Delivery Location
  • Qry
  • Qry Count Current Raizcorp Possibles by Delivery Location
  • Delivery Locations

Columns Selected

  • [Delivery Locations].[Delivery Location]
  • [Delivery Locations].[Raizcorpossibles Target]
  • IIf(IsNull([Current Raizcorp Possibles]),0,[Current Raizcorp Possibles])
  • IIf(IsNull([Current Number Part Sponsorship]),0,[Current Number Part Sponsorship
  • IIf(IsNull([Current Part Sponsorship Amt]),0,[Current Part Sponsorship Amt])

Order By

[Delivery Locations].[Delivery Location]

SQL

SELECT [Delivery Locations].[Delivery Location], [Delivery Locations].[Raizcorpossibles Target], IIf(IsNull([Current Raizcorp Possibles]),0,[Current Raizcorp Possibles]), IIf(IsNull([Current Number Part Sponsorship]),0,[Current Number Part Sponsorship, IIf(IsNull([Current Part Sponsorship Amt]),0,[Current Part Sponsorship Amt]) FROM [Qry Get Del Loc Raizcorpossibles Part Sponsorship], [Qry Count Current Raizcorp Possibles by Delivery Location], [Delivery Locations], [Qry Count Current Part Sponsorship by Delivery Location]