Skip to content

Query: Qry Report Selection Team Targets

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

Tables Referenced

  • Qry Count Entreprenur Steps Total at 8
  • Qry Count Entreprenur Steps Total at 1 and 4
  • Qry Count Entreprenur Steps Total at 1 and 3
  • Qry Count Entreprenur Steps Total at 1
  • Qry Count Entreprenur Steps Total at 3
  • Qry Count Entreprenur Steps Total at 2
  • Qry Count Entreprenur Steps Total at 1 and 8
  • Qry
  • Qry Count Entreprenur Steps Total at 7
  • Qry Count Entreprenur Steps Total at 4
  • Qry Get OwnedBy for Selection Team Target Report
  • Qry Count Entreprenur Steps Total at 1 and 7
  • Qry Count Entreprenur Steps Total at 1 and 2

Columns Selected

  • OwnedBy
  • [Qry Count Entreprenur Steps Total at 1].[Total at Step 1]
  • [Qry Count Entreprenur Steps Total at 2].[Total at Step 2]
  • [Qry Count Entreprenur Steps Total at 1 and 2].[Total at Step 1 and 2]
  • [Total at Step 1 and 2]/[Total at Step 1]
  • [Qry Count Entreprenur Steps Total at 3].[Total at Step 3]
  • [Qry Count Entreprenur Steps Total at 1 and 3].[Total at Step 1 and 3]
  • [Total at Step 1 and 3]/[Total at Step 1]
  • [Qry Count Entreprenur Steps Total at 4].[Total at Step 4]
  • [Qry Count Entreprenur Steps Total at 1 and 4].[Total at Step 1 and 4]
  • [Total at Step 1 and 4]/[Total at Step 1]
  • [Qry Count Entreprenur Steps Total at 7].[Total at Step 7]
  • [Qry Count Entreprenur Steps Total at 1 and 7].[Total at Step 1 and 7]
  • [Total at Step 1 and 7]/[Total at Step 1]
  • [Qry Count Entreprenur Steps Total at 8].[Total at Step 8]
  • [Qry Count Entreprenur Steps Total at 1 and 8].[Total at Step 1 and 8]
  • [Total at Step 1 and 8]/[Total at Step 1]

Where Clause

((([Qry Get OwnedBy for Selection Team Target Report].OwnedBy) Is Not Null))

SQL

SELECT [Qry Get OwnedBy for Selection Team Target Report].OwnedBy, [Qry Count Entreprenur Steps Total at 1].[Total at Step 1], [Qry Count Entreprenur Steps Total at 2].[Total at Step 2], [Qry Count Entreprenur Steps Total at 1 and 2].[Total at Step 1 and 2], [Total at Step 1 and 2]/[Total at Step 1], [Qry Count Entreprenur Steps Total at 3].[Total at Step 3], [Qry Count Entreprenur Steps Total at 1 and 3].[Total at Step 1 and 3], [Total at Step 1 and 3]/[Total at Step 1], [Qry Count Entreprenur Steps Total at 4].[Total at Step 4], [Qry Count Entreprenur Steps Total at 1 and 4].[Total at Step 1 and 4], [Total at Step 1 and 4]/[Total at Step 1], [Qry Count Entreprenur Steps Total at 7].[Total at Step 7], [Qry Count Entreprenur Steps Total at 1 and 7].[Total at Step 1 and 7], [Total at Step 1 and 7]/[Total at Step 1], [Qry Count Entreprenur Steps Total at 8].[Total at Step 8], [Qry Count Entreprenur Steps Total at 1 and 8].[Total at Step 1 and 8], [Total at Step 1 and 8]/[Total at Step 1] FROM [Qry Get OwnedBy for Selection Team Target Report], [Qry Count Entreprenur Steps Total at 1], [Qry Count Entreprenur Steps Total at 1 and 2], [Qry Count Entreprenur Steps Total at 2], [Qry Count Entreprenur Steps Total at 4], [Qry Count Entreprenur Steps Total at 7], [Qry Count Entreprenur Steps Total at 3], [Qry Count Entreprenur Steps Total at 1 and 3], [Qry Count Entreprenur Steps Total at 1 and 4], [Qry Count Entreprenur Steps Total at 1 and 7], [Qry Count Entreprenur Steps Total at 8], [Qry Count Entreprenur Steps Total at 1 and 8] WHERE ((([Qry Get OwnedBy for Selection Team Target Report].OwnedBy) Is Not Null))