Hi all. I'm trying to categorize order data and compare rush orders against previous order history. I've created two queries 'Rush' and 'Orders' to gather only the orders I'm interested in. What I'd like to do now is categorize each line in the 'Rush' query to determine if the ordered part has ever appeared in the query 'Orders'. When the part doesn't appear in the query 'Orders' I'd like to tag it "First Time Demand" and those that do appear "Repeat Demand". The common field between the two queries is 'PartNbr'. Not sure if this is possible and would appreciate any assistance.