Hi guys, I've hit a bit of a "Pickle", so I'm hoping some boffins might be able to assist me? I am trying to use a query to filter my ParticipantTable to find relevant information. In my ParticipantTable I have the following fields of interest:
1. ID (Primary Key)
2. UniqueParticipantNumber (provides flexibility to track duplicate participants)
3. ParticipantFirstName
4. Transferred ("In" or "Out" combo box)
Participants are essentially tenants who can stay in a property for indefinite periods of transfer "In" and "Out" of properties frequently. The data I am trying to extract are participants who have either Transferred "Out" (not "In") or have NOT Transferred "In" (not become a tenant). I believe what I need to do (which I don't know how to) is:
- Search participants who do NOT have duplicate UniqueParticipantNumbers
- Have Transferred "Out" (but not transferred "In" another property)
- Have not yet become tenants
Looking forward to your help....thanks guys....
Kind regards, Steve
1. ID (Primary Key)
2. UniqueParticipantNumber (provides flexibility to track duplicate participants)
3. ParticipantFirstName
4. Transferred ("In" or "Out" combo box)
Participants are essentially tenants who can stay in a property for indefinite periods of transfer "In" and "Out" of properties frequently. The data I am trying to extract are participants who have either Transferred "Out" (not "In") or have NOT Transferred "In" (not become a tenant). I believe what I need to do (which I don't know how to) is:
- Search participants who do NOT have duplicate UniqueParticipantNumbers
- Have Transferred "Out" (but not transferred "In" another property)
- Have not yet become tenants
Looking forward to your help....thanks guys....
Kind regards, Steve