Recent content by vfxd

Thanks for the reply pr2-eugin. I think the SQL you posted would include all unique combinations of the three fields. But I only wanted to include fields which have *more than one* possible FoodClass value for a given AcctNum+FoodType pair. The SQL I posted in answering my own question does...

I think I'm close to figuring this out. There's probably an easier way, but for others who come across this post, the below query will return a list of AcctNum + FoodType pairs which have more than 1 different value for FoodClass. From here I can create another query to give me the full list...

PS -- I'm not trying to delete these semi-duplicates, I'm just trying to identify them & create a recordset with them. I'm happy to send $5 via PayPal to the (first) person who can help me with the SQL. Thanks.

I'm trying to determine the SQL to return only those records in a table which have duplicate values in each of two fields, but different values in a third field. Here's an example: AcctNum FoodType FoodClass ------- -------- --------- A123 Apple Fruit A123 Apple Fruit...

Thanks for the suggestions! I think I got it using sxschech's suggestion. Not sure if I anonymized for the fake fruit data correctly, but here is what I'm using: SELECT a.Owner, a.Location, a.Type, Count(a.FruitID) As CountForOwnerLocType, CountForOwnerLocType / b.CountForOwnerType FROM...

I have a table with the following sample data (the data and field names are fictionalized... I'm not trying to track pieces of fruit!): FruitID Owner Location Type ------- ------ -------- ---- 1 John New York Apple 2 John New York Apple 3 John New York...