Skip to content

Query: Qry Count Number Months Billed by Company PP and Project Pillar

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

Tables Referenced

  • Entrepreneur
  • Entrepreneur Company Monthly Billings
  • Entrepreneur Company Principal Projects

Columns Selected

  • [Entrepreneur Company Monthly Billings].[Entrepreneur Company Principal Project
  • [Entrepreneur Company Monthly Billings].[Principal Project Pillar ID]
  • Count([Entrepreneur Company Monthly Billings].[Entrepreneur Company Billings ID]

SQL

SELECT [Entrepreneur Company Monthly Billings].[Entrepreneur Company Principal Project , [Entrepreneur Company Monthly Billings].[Principal Project Pillar ID], Count([Entrepreneur Company Monthly Billings].[Entrepreneur Company Billings ID] FROM [Entrepreneur Company Monthly Billings], [Entrepreneur Company Principal Projects]