I am trying to get my data consistant in an access file containing my banking information. I download the transactions in *.csv format and then import them into access. The field data naming conventions varies sometimes so I want to update the field data to be consistant. The problem is I don't want to have to create 50 different queries to accomplish this. I found some info on the net as below where I can accomplish this with one query but can't seem to figure it out. I could then run this one query every few months or so and bingo my data would look nice and neat!
Trying to use SQL and am a newbie..

UPDATE Checking
SET Payee = Date
WHEN LIKE '*CAPITAL*' THEN 'CAPITAL ONE'
WHEN LIKE '*WAL*' THEN 'WAL-MART'
WHEN LIKE '*PEN*' THEN 'JC PENNEY'
WHEN LIKE' *KOH*' THEN 'KOHLS'
When Like' *so*' THEN 'SO ON AND SO FORTH'
END
WHERE Checking.Date >#1/1/2012#

Hi,

What version of Access are you using? Knowing the Access version may help us determine a more appropriate response to your question.

That doesn't look like Access SQL (at least I am not familiar with it). Where did you get it? Is it maybe a T-SQL syntax?

Perhaps you'd be able to get the same thing using the Replace() function.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

Version is 2003
the "Replace" will work for me I'm just trying to come up with some way to accomplish this.

Here is the link which got me started on this: http://www.karlrixon.co.UK/writing/update-...ngle-sql-query/

...SQL

This post has been edited by arnelgp: Mar 4 2012, 11:42 AM

Thanks, Arnel. I did find a similar example in T-SQL at MSDN.