I have a continuous list of records, I want to change the selection criteria .
How can I do it in vba.
I know I have to construct a variable that the user has to enter what they want to search for. Then a WHERE statement
Any help would be appreciated
How can I do it in vba.
Code:
SELECT Orders.OrdersId, Orders.OrderNo, Orders.Arrived, Orders.DateArrived, Orders.AdditionalComments, Orders.OrderInstructions, Orders.Supplier, Orders.DateOrdered
FROM Orders
ORDER BY Orders.OrderNo;
- to select the order number
- to select all records that have the same supplier
- to select all records have the same date ordered
Any help would be appreciated