Skip to content

Query: Qry Report VA Packs Required in Four Weeks

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

Tables Referenced

  • Principal Projects
  • Principals

Columns Selected

  • [Principal Projects].[Principal Project ID]
  • [Principal Projects].[Date Principal Requires Packs]
  • [Principal] & \
  • FYE
  • [Principal Projects].[Solutions Architect]

Where Clause

((([Principal Projects].[Date Principal Requires Packs])>Date() And ([Principal

SQL

SELECT [Principal Projects].[Principal Project ID], [Principal Projects].[Date Principal Requires Packs], [Principal] & \, Principals.FYE, [Principal Projects].[Solutions Architect] FROM [Principals], [Principal Projects] WHERE ((([Principal Projects].[Date Principal Requires Packs])>Date() And ([Principal