Skip to content

Query: Qry Report Books Not Submitted Both Bookkeepers

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

Tables Referenced

  • SubQry
  • Qry Get Companies Assigned Both Bookkeepers
  • SubQry Rpt Books Not Submitted Raizcorp Bookkeeper

Columns Selected

  • [Qry Get Companies Assigned Both Bookkeepers].[Delivery Location]
  • [Qry Get Companies Assigned Both Bookkeepers].[RC Bookkeeper Assigned]
  • [Qry Get Companies Assigned Both Bookkeepers].[Company Name]
  • IIf([Own Bookkeeper]=True,\

Where Clause

((([SubQry Rpt Books Not Submitted Raizcorp Bookkeeper].[Entrepreneur Company ID

Order By

[SubQry Rpt Books Not Submitted Raizcorp Bookkeeper].[Entrepreneur Company ID]

SQL

SELECT [Qry Get Companies Assigned Both Bookkeepers].[Delivery Location], [Qry Get Companies Assigned Both Bookkeepers].[RC Bookkeeper Assigned], [Qry Get Companies Assigned Both Bookkeepers].[Company Name], IIf([Own Bookkeeper]=True,\ FROM [SubQry Rpt Books Not Submitted Raizcorp Bookkeeper], [Qry Get Companies Assigned Both Bookkeepers] WHERE ((([SubQry Rpt Books Not Submitted Raizcorp Bookkeeper].[Entrepreneur Company ID