Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access Table Design
link question
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Bill, post: 2553377"] I put a linked table to SQL Server in an Access 2003 database. The field I want to link on in the SQL db is a social security number without the dashes (123456780) while the SSN in the Access table is 123-45-6780. I tried using the MID function to parse the linked fields and retrieve another field from the SQL database based on the SSN. Does anyone have any ideas on a good way to do this? Thanks [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access Table Design
link question
Top