Skip to content

Query: Qry Report Bookkeeper Tracker

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

Tables Referenced

  • Qry Count Companies Assigned by Bookkeeper
  • SubQry Rpt Tracker Count Previous Incomplete Subs by Bookkeeper
  • Qry
  • SubQry Rpt Tracker Count Current Submissions by Bookkeeper
  • SubQry Rpt Tracker Count Current Complete Subs by Bookkeeper
  • SubQry Rpt Tracker Count Current Under Query Subs by Bookkeeper
  • SubQry Rpt Tracker Count Current Incomplete Subs by Bookkeeper

Columns Selected

  • [Qry Count Companies Assigned by Bookkeeper].[Delivery Location]
  • [Qry Count Companies Assigned by Bookkeeper].[RC Bookkeeper Assigned]
  • [Qry Count Companies Assigned by Bookkeeper].[Their Own Bookkeeper]
  • [Qry Count Companies Assigned by Bookkeeper].[Number Assigned]
  • IIf(IsNull([Number Submitted]),0,[Number Submitted])
  • [Number Assigned]-[Submitted]
  • IIf(IsNull([Complete Submissions]),0,[Complete Submissions])
  • IIf(IsNull([Incomplete Submissions]),0,[Incomplete Submissions])
  • IIf(IsNull([Under Query Submissions]),0,[Under Query Submissions])
  • IIf(IsNull([Number Submitted]) Or [Number Submitted]=0,0,[Complete]/[Number Subm
  • IIf(IsNull([Number Submitted]) Or [Number Submitted]=0,0,([Incomplete]+[Under Qu
  • IIf(IsNull([Previous Incomplete Submissions]),0,[Previous Incomplete Submissions

Order By

[Qry Count Companies Assigned by Bookkeeper].[Delivery Location], [Qry Count Companies Assigned by Bookkeeper].[RC Bookkeeper Assigned], [Qry Count Companies Assigned by Bookkeeper].[Their Own Bookkeeper]

SQL

SELECT [Qry Count Companies Assigned by Bookkeeper].[Delivery Location], [Qry Count Companies Assigned by Bookkeeper].[RC Bookkeeper Assigned], [Qry Count Companies Assigned by Bookkeeper].[Their Own Bookkeeper], [Qry Count Companies Assigned by Bookkeeper].[Number Assigned], IIf(IsNull([Number Submitted]),0,[Number Submitted]), [Number Assigned]-[Submitted], IIf(IsNull([Complete Submissions]),0,[Complete Submissions]), IIf(IsNull([Incomplete Submissions]),0,[Incomplete Submissions]), IIf(IsNull([Under Query Submissions]),0,[Under Query Submissions]), IIf(IsNull([Number Submitted]) Or [Number Submitted]=0,0,[Complete]/[Number Subm, IIf(IsNull([Number Submitted]) Or [Number Submitted]=0,0,([Incomplete]+[Under Qu, IIf(IsNull([Previous Incomplete Submissions]),0,[Previous Incomplete Submissions FROM [Qry Count Companies Assigned by Bookkeeper], [SubQry Rpt Tracker Count Current Submissions by Bookkeeper], [SubQry Rpt Tracker Count Current Complete Subs by Bookkeeper], [SubQry Rpt Tracker Count Current Incomplete Subs by Bookkeeper], [SubQry Rpt Tracker Count Previous Incomplete Subs by Bookkeeper], [SubQry Rpt Tracker Count Current Under Query Subs by Bookkeeper]