I need to return some access records where a field doesn't contain two specific text strings.
I am using the following to build the querystrQuery = "SELECT InvDate, Agent, BoxRef, Supplier, Invoice FROM SageData WHERE (Supplier Not Like '*CNG*' AND Supplier Not Like '*Swalec*') AND InvDate = #"...