I am working on a MS ACCESS database in which users take a simple "Yes" and "No" survey (See Attachment). The survey use's Social Security Numbers as the primary key. I realize this isn't normal, however, my military "customer" requires the SSN for this application, so I have no way around it. I must use the full SSN. The database application functions perfectly except for when a user has a "Zero" in the beginning of their SSN. I have set the data type to text and the input mask is set to be a SSN. I have provided the original database (See Attachment) where the SSN was originally a field named "PerticipantID". This eventually became the SSN in the final application. I migrated this survey application into my finished application with little trouble. It wasn't until users started using the new survey, that I identified the issue, so I checked the provided original (See Attachment) and that too is having the same issue. I had originally thought I missed something, but when I saw the original survey had the same issue, I realized is must be something else. Note: Anyone else with any other SSN or Participant ID other than one that starts with a "Zero" works just the way I wanted it to. Any assistance you could provide after review of this survey will be greatly appriciated.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.