Skip to content

Query: Qry People Payroll Information List

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

Tables Referenced

  • People
  • People Payroll Information

Columns Selected

  • [People Payroll Information].[People Payroll Information ID]
  • [People Payroll Information].[People ID]
  • [People Payroll Information].[Date Captured]
  • [People Payroll Information].[Payroll Item]
  • [Payroll Period Month] & \
  • Notes
  • IIf([Actioned]=1,\

SQL

SELECT [People Payroll Information].[People Payroll Information ID], [People Payroll Information].[People ID], [People Payroll Information].[Date Captured], [People Payroll Information].[Payroll Item], [Payroll Period Month] & \, [People Payroll Information].Notes, IIf([Actioned]=1,\ FROM [People Payroll Information]