Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

shows value only

Status
Not open for further replies.
nuglorious

nuglorious

IS-IT--Management
Nov 29, 2002
24
SG
hi there
In query, i have 1 column which shows currency and value together like this USD 1000. So I would like to shows value only. I would appreciate anyone could help me solve this problem. :(

thank you
nuglorious
 
Sort by date Sort by votes
SELECT Replace(Myfield, 'USD ', '') as currfield from mytable

-DNG
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
1K
TheresAlwaysAWay
TheresAlwaysAWay
Hanss
  • Locked
  • Question
Query which shows results?
Replies
2
Views
343
dhookom
dhookom
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
2K
combo
combo
TrekBiker
  • Locked
  • Question
Find records containing another field value 1
Replies
9
Views
508
Andrzejek
Andrzejek
LittleSmudge
  • Locked
  • Question
Value from Field [Price] for most recent dated record
Replies
3
Views
231
LittleSmudge
LittleSmudge

Part and Inventory Search

Sponsor

Back
Top