Skip to content

Query: Qry Report Principal Project Information

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

Tables Referenced

  • Client Tiers
  • PrincipalProjectStatus
  • Principal
  • Principal Projects
  • Channel Partners
  • Principals
  • IndustryLookup

Columns Selected

  • [Principal Projects].[Principal Project ID]
  • Principal
  • Principals.[Principal Address 1]
  • Principals.[Principal Address 2]
  • Principals.[Principal Address 3]
  • Principals.[Principal Address 4]
  • [Channel Partners].[Channel Partner]
  • [Contact First Name] & \
  • Industry
  • Principals.[Industry Notes]
  • FYE
  • [Client Tiers].[Client Tier]
  • [Principal Projects].[Project Name]
  • [Principal Projects].[Solutions Architect]
  • [Principal Projects].[Contract Type]
  • Status
  • [Principal Projects].[Brief Date]
  • [Principal Projects].[Contract Start Date]

Where Clause

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

SQL

SELECT [Principal Projects].[Principal Project ID], Principals.Principal, Principals.[Principal Address 1], Principals.[Principal Address 2], Principals.[Principal Address 3], Principals.[Principal Address 4], [Channel Partners].[Channel Partner], [Contact First Name] & \, IndustryLookup.Industry, Principals.[Industry Notes], Principals.FYE, [Client Tiers].[Client Tier], [Principal Projects].[Project Name], [Principal Projects].[Solutions Architect], [Principal Projects].[Contract Type], PrincipalProjectStatus.Status, [Principal Projects].[Brief Date], [Principal Projects].[Contract Start Date] FROM [Principal Projects], [Principals], [Channel Partners], [IndustryLookup], [PrincipalProjectStatus], [Client Tiers] WHERE ((([Principal Projects].[Principal Project ID])=[Forms]![Frm Principal Project R