View Single Post
Old 08-12-2019, 12:01 PM   #5
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,271
Thanks: 15
Thanked 1,595 Times in 1,515 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Query records with same ID Number

All in all, it is far better to never mush multiple pieces of data in a single field. You don't save anything. All you do is add complexity. Best solution is to separate SSN and the trailing character into two fields. You can use a compound unique index if you need to. Indexes can contain up to 10 fields. You have to build compound indexes using the indexes dialog. You cannot build them using design view on the table.

And finally, SSN should NEVER, EVER be used as a primary key. There are privacy lasw that prevent that. Hope you are not violating them.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote