Anyone have a query to looks at items and transaxtions to see what customers are not buying?

Don't have the query. But you can implement some nested queries. For example. Query on item record where you find all your active item or whatever criteria you need to put. And in the where part you can add one more condition NOT IN and Then do a query on transactions between certain dates and get all the items. grououp those items so you can unique item list. Whatever items you get will be the ones that are not used in any transaction between that duration.