I have a search created that shows how many of that item we sold in a certain time frame, how can I get it to tell me if it was 0 ?

Throw NVL({formula},0) into the search?

Then you must do an item search and join the transaction table