anniesolomon
Technical User
I often have several requisitions on backorder against the same vendor contract and want to group them together so I only have to type my follow up notes one time. In other words, instead of having several TrackingNumber records, I just want one. I want to design a report that alerts me when a StockNumber has more than one (different) TrackingNumber so I can decide (based on the status of the order) whether or not to combine with an already established TrackingNumber. I tried grouping on the StockNumber and using Count([TrackingNumber]) > 1 but that doesn't work. I need to know when the TrackingNumber fields are different for a given StockNumber.