ACCESS FEED: RE: [MS_AccessPros] convert numbers to text

Minggu, 21 Juli 2013

RE: [MS_AccessPros] convert numbers to text

UPDATE MyTable
SET CurField = Choose([CurField], "Dollar", "Euro", "Pound")

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of as_milone
Sent: Sunday, July 21, 2013 3:26 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] convert numbers to text

thanks.
I know we could do that using a middle table but i am asking how to do that
without creation for another table as we use one update query with one
criterion using some functions like (if-else).
could we do that?

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom
<duanehookom@...> wrote:
>
> I tend to use tables :-)
>
> Create a small table [tblCurrency] with a primary key numeric (or text if
your number is text) field [CurrID] and a text field [CurrName]. Then add
the records:
>
> 1 Dollar
> 2 Euro
> 3 Pound
>
> You can then use this table with your original table in an update query.
Update your numeric fields with the value from CurrName.
>
> Duane Hookom MVP
> MS Access
>
> ----------------------------------------
> > From: no_reply@yahoogroups.com
> >
> > Hi:
> > I have a column includes the value either 1 or 2 or 3, and I want to
> > convert 1 to "Dollar",2 to "Euro", and 3 to "Pound".I know how to
> > use an update query with one criterion so I need three update
> > queries. How could I use one update query to accomplish theses
> > transactions as a batch.
> > Thanks
> > note: using access 2003
> >
>

------------------------------------

Yahoo! Groups Links