Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 08-19-2019, 11:24 PM   #1
Steve G
Newly Registered User
 
Join Date: Aug 2019
Posts: 19
Thanks: 2
Thanked 0 Times in 0 Posts
Steve G is on a distinguished road
Query Duplicate Records

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

Steve G is offline   Reply With Quote
 

Tags
query 3 columms table

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Append query duplicate records hardyd44 Queries 2 04-12-2010 04:34 AM
need help to query without duplicate records help smig Queries 9 04-03-2010 09:09 AM
help in query. duplicate records zibzaba Queries 2 02-16-2010 06:48 AM
Query for duplicate records zaphod2003 Queries 3 07-09-2007 06:57 AM
Eliminate Duplicate Records in a Query jereece Queries 2 06-06-2007 05:32 AM




All times are GMT -8. The time now is 06:25 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World