Yes there is, apologies for that:
| GroupID | MyName | Age | Rating | Animal | Mood |
|---|---|---|---|---|---|
17 | Kevin | 1 | 4 | Tiger | Good |
17 | Kevin | 1 | 4 | Giselle | Good |
Solved Creating a query with unique records using complicated filtering fields?
- Thread starter 6thDAY
- Start date
Correct, either the first of the group IIF "all" records are GOOD, or the first BAD of the group.
The results are almost correct except one minor issue.
The original Query 1 with GroupID = 20:
Your updated Output code for GroupID = 20:
There appears to be a duplicate where Leopard = Bad, and Cheetah = Good. It should just should Leopard = Bad.
The original Query 1 with GroupID = 20:
| GroupID | MyName | Age | Rating | Animal | Mood |
|---|---|---|---|---|---|
20 | David | 1 | 1 | Leopard | Good |
20 | David | 1 | 2 | Cheetah | Good |
20 | David | 1 | 2 | Leopard | Bad |
20 | David | 1 | 3 | Cheetah | Good |
20 | David | 1 | 3 | Leopard | Good |
Your updated Output code for GroupID = 20:
| GroupID | MyName | Age | Rating | Animal | Mood |
|---|---|---|---|---|---|
20 | David | 1 | 1 | Leopard | Good |
20 | David | 1 | 2 | Leopard | Bad |
20 | David | 1 | 2 | Cheetah | Good |
20 | David | 1 | 3 | Leopard | Good |
There appears to be a duplicate where Leopard = Bad, and Cheetah = Good. It should just should Leopard = Bad.
Excellent, I ran a No Duplicate query and saw none.
Last edited:
