ugh. I mean, the search is well designed generally and the formatting being set to drop right into their system is a big plus but little things like using the vendor join to pull the address instead of the the billing address from the transaction itself causes duplicated results if the vendor has multiple addresses. That's not a 'basic' thing, but if you're building a saved search with 15 case when statements I'd expect you to think of stuff like that....anyway, thanks for confirming I'm not nuts.