Search results

Hi Gurus, I have a table like this. ProductCode, Qty, SalesPrice, Customer 1001 , 10 , $1000 , A 1001 , 10 , $1000 , B 2001 , 10 , $3000 , A 3001 , 15 , $3000 , A 4001 ...

Hi all MS Access Gurus, I wanted to create a query to query which products have never been purchased in the year of 2014-2015. I have a record of Sales order as below. The sales order will has the below fields ID Customer Date ProductCode Quantity 1 CustomerA 2/3/2012 1001 10 2...