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
> >
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar