Skip to content

Query: SubQry Rpt Percent Raizcorp Possibles Moved Last Week

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

Tables Referenced

  • Qry
  • Qry Count Raizcorp Possibles Moved Last Week by Delivery Loc
  • Qry Count Current Raizcorp Possibles by Delivery Location
  • Distribution Models
  • Delivery Locations

Columns Selected

  • [Delivery Locations].[Delivery Location ID]
  • [Distribution Models].[Distribution Model]
  • [Delivery Locations].[Delivery Location]
  • IIf(IsNull([Moved Raizcorp Possibles]),0,[Moved Raizcorp Possibles])
  • IIf(IsNull([Current Raizcorp Possibles]),0,[Current Raizcorp Possibles])
  • [Current]+[Moved]
  • [Moved]/[Total]

Where Clause

(((IIf(IsNull([Moved Raizcorp Possibles]),0,[Moved Raizcorp Possibles]))<>0)) OR

SQL

SELECT [Delivery Locations].[Delivery Location ID], [Distribution Models].[Distribution Model], [Delivery Locations].[Delivery Location], IIf(IsNull([Moved Raizcorp Possibles]),0,[Moved Raizcorp Possibles]), IIf(IsNull([Current Raizcorp Possibles]),0,[Current Raizcorp Possibles]), [Current]+[Moved], [Moved]/[Total] FROM [Qry Count Current Raizcorp Possibles by Delivery Location], [Delivery Locations], [Qry Count Raizcorp Possibles Moved Last Week by Delivery Loc], [Distribution Models] WHERE (((IIf(IsNull([Moved Raizcorp Possibles]),0,[Moved Raizcorp Possibles]))<>0)) OR