thingssocomplex
Registered User.
- Local time
- Today, 08:28
- Joined
- Feb 9, 2009
- Messages
- 178
I am stumped - I have a table from another database, set out like below
FirstName LastName ClientID
Joe Bloggs IB34568
Jan Bloggs IB34568
Ideally within a query I would like to add an additional field named "Joint" and pre-populate with a "Yes" or a "No" not all of the clients within the table will have duplicate Client ID's only joint clients! An example of how I would like the output is below, it does not matter which first name appears, there just needs to be one row; is this possible?
FirstName LastName ClientID Joint
Joe Bloggs IB34568 Yes
FirstName LastName ClientID
Joe Bloggs IB34568
Jan Bloggs IB34568
Ideally within a query I would like to add an additional field named "Joint" and pre-populate with a "Yes" or a "No" not all of the clients within the table will have duplicate Client ID's only joint clients! An example of how I would like the output is below, it does not matter which first name appears, there just needs to be one row; is this possible?
FirstName LastName ClientID Joint
Joe Bloggs IB34568 Yes