If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
link question
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 |
#2
|
|||
|
|||
Are both fields text? You can remove the "-" from a field/value using
Replace([SSN],"-","") -- Duane Hookom MS Access MVP "Bill" wrote in message news 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 |
#3
|
|||
|
|||
Yes, both fields are text. So where would I perform this replace? I don't
really want to change the actual data but retrieve a field from the linked SQL Server table based on the SSN join. I was trying to use a lookup field in the Access table using an SQL query for the record source. I'm not sure if I'm on the right track though. Thanks. "Duane Hookom" wrote in message ... Are both fields text? You can remove the "-" from a field/value using Replace([SSN],"-","") -- Duane Hookom MS Access MVP "Bill" wrote in message news 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 |
#4
|
|||
|
|||
You can add both tables to your query and set the criteria under the field
without the "-" to =Replace([SSNwith-],"-","") -- Duane Hookom MS Access MVP "Bill" wrote in message . .. Yes, both fields are text. So where would I perform this replace? I don't really want to change the actual data but retrieve a field from the linked SQL Server table based on the SSN join. I was trying to use a lookup field in the Access table using an SQL query for the record source. I'm not sure if I'm on the right track though. Thanks. "Duane Hookom" wrote in message ... Are both fields text? You can remove the "-" from a field/value using Replace([SSN],"-","") -- Duane Hookom MS Access MVP "Bill" wrote in message news 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
W. '97 totally shut down on me | Doug | General Discussion | 20 | September 2nd, 2004 06:32 AM |
Still having Web Page Pathing Problems / Relative Links show Netwo | webmaster | Powerpoint | 27 | July 15th, 2004 11:16 PM |
Removing a hidden link to an extern worksheet | Geo Siggy | Worksheet Functions | 3 | February 9th, 2004 04:13 PM |
Network User Name Link On Forms | wwoodall | Worksheet Functions | 0 | January 14th, 2004 08:06 PM |
Charting in a single cell question... | LSMark | Charts and Charting | 3 | January 8th, 2004 03:00 PM |