Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    29

    Unanswered: Filtering equal values

    I have three fields I'm filtering on a tabular form.
    If I come up with 10 matches but in 5 of the records all three fields are equal. I would want to display the 5 records that are not equal and only one from the 5 that are equal.

    Example

    ......................#1......#2.....#3
    Record#1...........a........b......x
    Record#2...........a........b......x
    Record#3...........a........b......y
    Record#4...........a........c......x

    If I ran a filter on any of the three fields I would not want record #1 and #2 to show up in the same filter since all three fields are equal.


    Chris
    Last edited by chrisn6104; 11-04-04 at 16:13.

  2. #2
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    I would build an underlying select query that groups on field 1, 2, and 3 and either counts or selects the min or selects the max of Record# field, and then use the query as my datasource for the form. This would work if you are filtering on field 1, 2, or 3, but not if you wanted to filter based upon the Record# field.

  3. #3
    Join Date
    Oct 2004
    Posts
    29
    I see thanks

    I just had my query laid out wrong.

Posting Permissions

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