Skip to content

Query: Qry Report Team Activity Detail

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

Tables Referenced

  • vwRubyPreReportTeamActivityDetail

Columns Selected

  • vwRubyPreReportTeamActivityDetail.[Date Status Changed]
  • vwRubyPreReportTeamActivityDetail.[Status Modified By]
  • Job
  • vwRubyPreReportTeamActivityDetail.[Pay Point]
  • vwRubyPreReportTeamActivityDetail.[Position Effective Date]
  • Applicant
  • vwRubyPreReportTeamActivityDetail.[Application Status]
  • vwRubyPreReportTeamActivityDetail.[Sort Order]
  • vwRubyPreReportTeamActivityDetail.[Application Status History ID]
  • vwRubyPreReportTeamActivityDetail.[Time Unit]

Where Clause

(((vwRubyPreReportTeamActivityDetail.[Date Status Changed])>=[Forms]![Frm Team A

Order By

vwRubyPreReportTeamActivityDetail.[Status Modified By], vwRubyPreReportTeamActivityDetail.Job, vwRubyPreReportTeamActivityDetail.[Position Effective Date], vwRubyPreReportTeamActivityDetail.Applicant, vwRubyPreReportTeamActivityDetail.[Sort Order]

SQL

SELECT vwRubyPreReportTeamActivityDetail.[Date Status Changed], vwRubyPreReportTeamActivityDetail.[Status Modified By], vwRubyPreReportTeamActivityDetail.Job, vwRubyPreReportTeamActivityDetail.[Pay Point], vwRubyPreReportTeamActivityDetail.[Position Effective Date], vwRubyPreReportTeamActivityDetail.Applicant, vwRubyPreReportTeamActivityDetail.[Application Status], vwRubyPreReportTeamActivityDetail.[Sort Order], vwRubyPreReportTeamActivityDetail.[Application Status History ID], vwRubyPreReportTeamActivityDetail.[Time Unit] FROM [vwRubyPreReportTeamActivityDetail] WHERE (((vwRubyPreReportTeamActivityDetail.[Date Status Changed])>=[Forms]![Frm Team A