Data Type Problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Savas Ates" <savas@xxxxxxxxxxxxxxxxxxxx>
Date: Mon, 28 Nov 2005 18:39:41 +0200

I have a field in my table which has currency values like this
41.2
10
24.12

in my vb.net application i have a variable which i assigned as decimal

Dim mymoney as Decimal
mymoney =xx("mymoney")
I tried
Response.write mymoney

it returns 412 instead of 41.2

i tried
response.write xx("mymoney")

it returns 41.2

which kind of data type i should use ?

.

Follow-Ups:
- Re: Data Type Problem
  - From: Chris

Prev by Date: Re: Detect Uninitialized / Empty Array using .Net framework?
Next by Date: Re: Data Type Problem
Previous by thread: Printing problems
Next by thread: Re: Data Type Problem
Index(es):
- Date
- Thread

Relevant Pages

RE: Number to words literal
... change the argument data type if you need to. ... Function WordsAs String ... > I found many examples for currency but I need literal every number to word. ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)
Re: Rounding problems...
... If you need decimal places, you need a different data type -- try currency, ... but when I enter decimals it rounds them in the table ... Prev by Date: ...
(microsoft.public.access.tablesdbdesign)