Nwind_new - Invoices Filter

Description

Filters records in Invoice report. Referred to in the Click event of the Print button on the Orders form.

column	datatype	length	nulls	comment
ShipName	text	40	yes	Name of person or company to receive the shipment.
ShipAddress	text	60	yes	Street address only -- no post-office box allowed.
ShipCity	text	15	yes
ShipRegion	text	15	yes	State or province.
ShipPostalCode	text	10	yes
ShipCountry	text	15	yes
CustomerID	text	5	yes	Same entry as in Customers table.
Customers.CompanyName	text	40	no
Address	text	60	yes	Street or post-office box.
City	text	15	yes
Region	text	15	yes	State or province.
PostalCode	text	10	yes
Country	text	15	yes
Salesperson	text	0	yes
OrderID	long	4	yes	Unique order number.
OrderDate	datetime	8	yes
RequiredDate	datetime	8	yes
ShippedDate	datetime	8	yes
Shippers.CompanyName	text	40	no	Name of shipping company.
ProductID	long	4	no	Same as Product ID in Products table.
ProductName	text	40	no
UnitPrice	currency	8	no
Quantity	int	2	no
Discount	single	4	no
ExtendedPrice	currency	8	yes
Freight	currency	8	yes

name	type
Forms!Orders!OrderID	text

name	object type	level

SELECT DISTINCTROW
    Invoices.*
FROM Invoices
WHERE (((Invoices.OrderID)=Forms!Orders!OrderID));