Skip to content

Query: Qry Copy Application List

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

Tables Referenced

  • vwRubyPreApplicationList

Columns Selected

  • vwRubyPreApplicationList.[Stage Number]
  • vwRubyPreApplicationList.[Application ID]
  • vwRubyPreApplicationList.[Position ID]
  • vwRubyPreApplicationList.[People ID]
  • vwRubyPreApplicationList.[Application Status ID]
  • vwRubyPreApplicationList.[Application Status]
  • Applicant
  • vwRubyPreApplicationList.[Application Date]
  • vwRubyPreApplicationList.[Sort Order]
  • Int(DateDiff(\
  • vwRubyPreApplicationList.[PQ Score]

Where Clause

(((vwRubyPreApplicationList.[Stage Number])<>7 And (vwRubyPreApplicationList.[St

SQL

SELECT vwRubyPreApplicationList.[Stage Number], vwRubyPreApplicationList.[Application ID], vwRubyPreApplicationList.[Position ID], vwRubyPreApplicationList.[People ID], vwRubyPreApplicationList.[Application Status ID], vwRubyPreApplicationList.[Application Status], vwRubyPreApplicationList.Applicant, vwRubyPreApplicationList.[Application Date], vwRubyPreApplicationList.[Sort Order], Int(DateDiff(\, vwRubyPreApplicationList.[PQ Score] FROM [vwRubyPreApplicationList] WHERE (((vwRubyPreApplicationList.[Stage Number])<>7 And (vwRubyPreApplicationList.[St