Do you think the community's reply is helpful to you? And I will mark it. If the thread is marked unsatisfactorily, you can unmark it and continue to ask.
Best Regards,
Pengzhen
We are trying to better understand customer views on social support experience. Click HERE to participate the survey. Thanks!
melvintcs
Member
46 Points
252 Posts
datatype, error from text change to number
Feb 28, 2013 09:33 AM|melvintcs|LINK
i have a field name "amount", and been using for months.
the datatype of this field is "Text", so i go to the design view, change the datatype from "Text" to "Number".
after the changes my, it removed all my decimal place. such as
3.7 to 4
1.2 to 1
... etc
Any advice?
oned_gk
All-Star
50490 Points
14820 Posts
Re: datatype, error from text change to number
Feb 28, 2013 09:40 AM|oned_gk|LINK
Suwandi - Non Graduate Programmer
ashkc
Member
744 Points
245 Posts
Re: datatype, error from text change to number
Feb 28, 2013 01:10 PM|ashkc|LINK
change the datatype to decimal(10,2) or money or float...
in this three datatypes any one datatype will keeps your data as it is
melvintcs
Member
46 Points
252 Posts
Re: datatype, error from text change to number
Feb 28, 2013 07:25 PM|melvintcs|LINK
this is MS Access, i cannot choose any of the above u mentioned
Pengzhen Son...
Star
9886 Points
1291 Posts
Microsoft
Re: datatype, error from text change to number
Feb 28, 2013 11:35 PM|Pengzhen Song - MSFT|LINK
Hi,
You can try using single or double or currency.
ToughMan
Member
740 Points
546 Posts
Re: datatype, error from text change to number
Mar 02, 2013 04:14 AM|ToughMan|LINK
No.
For Access in NET, u should use decimal
Pengzhen Son...
Star
9886 Points
1291 Posts
Microsoft
Re: datatype, error from text change to number
Mar 07, 2013 04:50 AM|Pengzhen Song - MSFT|LINK
Hi again,
Do you think the community's reply is helpful to you? And I will mark it. If the thread is marked unsatisfactorily, you can unmark it and continue to ask.
Best Regards,
Pengzhen
ToughMan
Member
740 Points
546 Posts
Re: datatype, error from text change to number
Mar 07, 2013 05:07 AM|ToughMan|LINK
Money type in Access.
And decimal type in NET.
melvintcs
Member
46 Points
252 Posts
Re: datatype, error from text change to number
Mar 07, 2013 08:52 PM|melvintcs|LINK
these are the available datatype from my MS access, have a look
Pengzhen Son...
Star
9886 Points
1291 Posts
Microsoft
Re: datatype, error from text change to number
Mar 07, 2013 08:59 PM|Pengzhen Song - MSFT|LINK
Hi,
I think you can try using Currency datatype which is a huge scaled integer with exactly four decimal places.
Hope it can help you.
oned_gk
All-Star
50490 Points
14820 Posts
Re: datatype, error from text change to number
Mar 07, 2013 09:05 PM|oned_gk|LINK
Use double
Field Type : Number
Field Size : Double or Decimal
Another posible cousion is comma/dot format problem. Check regional setting in control panel.
Suwandi - Non Graduate Programmer