DaveCollins181
Registered User.
- Local time
- Today, 08:40
- Joined
- Oct 27, 2014
- Messages
- 45
I have two tables.
1) Suppliers
2) Purchase Orders - Has order date field
Suppliers is linked to Purchase orders via the Supplier ID field. I want to query all suppliers who have not placed an order in over 2 years. Can anyone assist with the query formula?
Thanks,
David.
1) Suppliers
2) Purchase Orders - Has order date field
Suppliers is linked to Purchase orders via the Supplier ID field. I want to query all suppliers who have not placed an order in over 2 years. Can anyone assist with the query formula?
Thanks,
David.