Re: link question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bill (WBeatty_at_Prodigy.Net)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 03:04:23 GMT

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" <duanehookom@NO_SPAMhotmail.com> wrote in message
news:#TEVHFezEHA.1204@TK2MSFTNGP10.phx.gbl...
> 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: Which identity?
    ... > Some postings I read suggested using MAXto retrieve the inserted record ... > each of these 3 SQL features? ... Another way to do it if using the .AddNew method on a Jet based ADO ... Dim rsTest As ADODB.Recordset ...
    (microsoft.public.access.queries)
  • Re: White Paper on How MSAccess interacts with SQL Server Back End
    ... these keys to retrieve the other fields from the tables by group of 10 rows. ... or with VBA functions that Access cannot translate directly into T-SQL ... Sylvain Lafontaine, ing. ... my SQL 2000 db using ACC2003 as the front end via linked tables. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Write Conflict MDB/SQL
    ... We went through in SQL and set the fields to default to 0 and the error ... "Duane Hookom" wrote: ... I found a posting by MS Access MVP Rick Brandt that suggested ... connections when I hit the SQL table - but on my 'control' table, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Write Conflict MDB/SQL
    ... "Duane Hookom" wrote: ... I found a posting by MS Access MVP Rick Brandt that suggested ... My SQL group tells me I ... connections when I hit the SQL table - but on my 'control' table, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Concatenating the same field from multiple records
    ... What's the "difference" for the SQL statement or actions being done for each ... <MS ACCESS MVP> ... Set dbs = CurrentDb ... "Ken Snell " wrote: ...
    (microsoft.public.access.queries)