Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009

    Question Unanswered: Supressing duplicates

    using multiple criteria?!

    Ok, I'm working on a database of property sales but I keep seeing duplicate sales. I need to supress certain data on the basis of duplicate propertyids, saledate AND saleprice. IOW: If the data in those all 3 of those fields is duplicated I need to supress it. If any of those three are different then is it a valid sale and needs to stay. Any ideas?

    I'm thinking maybe a nested IF but I'm not sure how that would work. IF propertyid=propertyid AND saledate=saledate AND saleprice=saleprice THEN supress...
    Last edited by msbclem; 11-20-09 at 11:04.

  2. #2
    Join Date
    Nov 2009

    Lightbulb Solving Duplicate Values

    The other thing you could do is to create a group based on the property id, sales date and sales price. Then at the group level you could check "Suppress if duplicate" to turn off the duplicates.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts