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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

conversion function

Status
Not open for further replies.
rq

rq

Programmer
Jun 13, 2002
56
US

I have a field that contains currency values. What function can I use to convert this currency field into an integer type?
 
Sort by date Sort by votes
If you want to do it within crystal.. it would be cint({table.field}). If you want your server to do the work we would need to know what type of DB you use.

Lisa
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J33
  • Locked
  • Question
Monthly exchange rates, select only newest rate on each currency for currency conversion on row
Replies
6
Views
286
J33
J33
nicmcd77
  • Locked
  • Question
Date Time Conversion Formula explanation
Replies
1
Views
98
hilfy
hilfy
azeemkhn
  • Locked
  • Question
is there any function in SQL SERVER
Replies
4
Views
164
kray4660
kray4660
JetRamsey
  • Locked
  • Question
How to grab highest value only. Date conversion. 1
Replies
1
Views
97
lbass
lbass
n2nuk
  • Locked
  • Question
SQL Expression date conversion error
Replies
2
Views
136
n2nuk
n2nuk

Part and Inventory Search

Sponsor

Back
Top