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 (2) |
Tidak ada komentar:
Posting Komentar