Update Multiple Records

[TexasStar]

Hello, I have searched for help on this but it just has me stumped. I
tried doing several different things, but none of them worked.

Here is the Scenario:

I have a table called Table1 and that table has several columns. Two
of the columns are titled 'State' and the other is titled 'API'.

The State fields are blank, and the API fields contain a number in
this format for example: 42-321-4567

What I am trying to do is update each State field based on the first 2
digits of the API number. I want to read each API, determine what 2
digit state code is represents and then update the State field with
the correct name for that state.

Can someone point me in the right direction and give me some help in
accomplishing this? Any help or advice would be greatly appreciated. I
just can't crack this and I feel like it should be something pretty
simple. I was thinking about setting up cases depending on what 2
digit code is trimmed and then run a special SQL update to set the
State field correctly, but I haven't been able to get it working. If
anyone could code me up an example that I could expand on it would be
greatly appreciated.

 

[John Spencer]

Answered in your earlier posting. Patience is a virtue. The responders
in these groups are all volunteers and someone will usually respond
within a few hours - but there are cases that take longer.

Usually the longer response times involve someone with the needed
knowledge seeing the question and having the time to respond.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[TexasStar]

Answered in your earlier posting. Patience is a virtue. The responders
in these groups are all volunteers and someone will usually respond
within a few hours - but there are cases that take longer.

Usually the longer response times involve someone with the needed
knowledge seeing the question and having the time to respond.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================









- Show quoted text -

I'm sorry for all the posts. It took about 10 hours before I could
even see my post and so I thought something was wrong with google
groups or something and that's why it wasn't showing up. Normally when
I make a post I see it a few minutes later, but for some reason this
one took almost a full day before it showed up. My apologies for the
multiple postings.