Skip to content

Query: Qry Report Principal SD Letter New Allocation

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

Tables Referenced

  • DatabaseUsers
  • Principals
  • Principal Projects
  • Principal

Columns Selected

  • [Principal Projects].[Principal Project ID]
  • Principal
  • [Principal Projects].[Project Name]
  • FYE
  • MonthName(Month([Principal Verified Date]))
  • [Transformation Contact First Name] & \
  • Principals.[Transformation Contact Position]
  • Principals.[Transformation Contact Email]
  • Principals.[Transformation Contact Cell]
  • [Procurement Contact First Name] & \
  • Principals.[Procurement Contact Position]
  • Principals.[Procurement Contact Email]
  • Principals.[Procurement Contact Cell]
  • [DatabaseUsers].[First Name] & \
  • DatabaseUsers.[Email Address]
  • [DatabaseUsers_1].[First Name] & \
  • DatabaseUsers_1.[Email Address]
  • DatabaseUsers_1.[Cell Phone Number]

Where Clause

((([Principal Projects].[Principal Project ID])=[Forms]![Frm Principal Report Da

SQL

SELECT [Principal Projects].[Principal Project ID], Principals.Principal, [Principal Projects].[Project Name], Principals.FYE, MonthName(Month([Principal Verified Date])), [Transformation Contact First Name] & \, Principals.[Transformation Contact Position], Principals.[Transformation Contact Email], Principals.[Transformation Contact Cell], [Procurement Contact First Name] & \, Principals.[Procurement Contact Position], Principals.[Procurement Contact Email], Principals.[Procurement Contact Cell], [DatabaseUsers].[First Name] & \, DatabaseUsers.[Email Address], [DatabaseUsers_1].[First Name] & \, DatabaseUsers_1.[Email Address], DatabaseUsers_1.[Cell Phone Number] FROM [Principal Projects], [Principals], [DatabaseUsers], [DatabaseUsers] WHERE ((([Principal Projects].[Principal Project ID])=[Forms]![Frm Principal Report Da