Query: Qry Product List Proposal

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

Tables Referenced

• Products Proposal
• Products

Columns Selected

• [Products Proposal].[Product ID]
• Product
• IIf([Active]=False,\

Order By

[Products Proposal].Product

SQL

SELECT [Products Proposal].[Product ID], [Products Proposal].Product, IIf([Active]=False,\ FROM [Products Proposal]