Skip to content

Query: SubQry Rpt How Heard Statistics Criteria

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

Tables Referenced

  • Applications
  • Positions

Columns Selected

  • Positions.[Position Effective Date]
  • Applications.[Application Status ID]
  • Applications.[How Heard About Position]
  • Applications.[Application ID]

Where Clause

(((Positions.[Position Effective Date])>=[Forms]![Frm Reports Date Dialog]![Star

SQL

SELECT Positions.[Position Effective Date], Applications.[Application Status ID], Applications.[How Heard About Position], Applications.[Application ID] FROM [Positions], [Applications] WHERE (((Positions.[Position Effective Date])>=[Forms]![Frm Reports Date Dialog]![Star