gojets1721
Registered User.
- Local time
- Today, 12:51
- Joined
- Jun 11, 2019
- Messages
- 429
I've got a bit of an odd project. See the attached example. Basically I'm looking to have a query pull in entries from the table ONLY when there's two entries that have the same field data. Basically, if two or more entries have the same customer ID and the same document date, then those entries should be pull it into the "2+ entry query.
Then I'm looking to create a separate query where if an entry's customer ID and document date match no other entry, it gets pulled into the "1 entry query"
So from my example, both John Sullivan entries and both Peter Sullivan entries would pull into a query together. Whereas the remaining two would pull into the "1 entry query"
I know its a weird request. I'm happy to explain further.
Then I'm looking to create a separate query where if an entry's customer ID and document date match no other entry, it gets pulled into the "1 entry query"
So from my example, both John Sullivan entries and both Peter Sullivan entries would pull into a query together. Whereas the remaining two would pull into the "1 entry query"
I know its a weird request. I'm happy to explain further.