Skip to content

Query: Qry People Admin Information List

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

Tables Referenced

  • People
  • People Admin Information

Columns Selected

  • [People Admin Information].[People Admin Information ID]
  • [People Admin Information].[People ID]
  • [People Admin Information].[Date Captured]
  • [People Admin Information].[Admin Item]
  • Notes
  • Duration
  • [People Admin Information].[Captured By]
  • IIf([Completed]=1,\

SQL

SELECT [People Admin Information].[People Admin Information ID], [People Admin Information].[People ID], [People Admin Information].[Date Captured], [People Admin Information].[Admin Item], [People Admin Information].Notes, [People Admin Information].Duration, [People Admin Information].[Captured By], IIf([Completed]=1,\ FROM [People Admin Information]