Re: link question

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 11/19/04 

Date: Thu, 18 Nov 2004 20:41:25 -0600

Are both fields text? You can remove the "-" from a field/value using
Replace([SSN],"-","") 

-- 
Duane Hookom
MS Access MVP
"Bill" <WBeatty@Prodigy.Net> wrote in message
news:o18nd.19422$nW4.14135@newssvr15.news.prodigy.com...
> 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
>
>

Relevant Pages

  • Re: Relational database & OO
    ... And when was the last time you saw an RDB that stored a telephone ... The modern relational theory permits to store values of user-defined type: ... Neither do the relational model or SQL. ... Your comprehension of the SQL database performance is not good. ...
    (comp.object)
  • Event log errors after moving sharepoint 3.0 database
    ... After following a procedure to move the location of the SQL databases from ... SQL Database 'WSS_Content' on SQL Server instance ... The local computer may not have the necessary registry ... information or message DLL files to display messages from a remote computer. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: ISA Log to SQL Database Question
    ... I am actually logging to an Access DB and the logs had grown to over 2 GB. ... The MSDE that comes with ISA or the real "full" MS SQL ... >> I have a question about ISA Logging to a SQL Database. ...
    (microsoft.public.isa.configuration)
  • RE: Automate Active Directory User Maintenance
    ... Hmmm...I know Quest has an ID management tool as well, but they are pricey. ... We've set it up for a client where the information is read from a SQL table ... could it evaulate the users in the SQL database ...
    (microsoft.public.windows.server.active_directory)
  • Re: Inventory and Stock Monitoring in Project
    ... through SQL. ... stock is used changing the information presented within the Inventory ... Inventory software places information in an SQL database which Project can ... VBA macros to keep track of stock. ...
    (microsoft.public.project)