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!
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?
All-Star
52302 Points
15573 Posts
Re: datatype, error from text change to number
Feb 28, 2013 09:40 AM|oned_gk|LINK
Suwandi - Non Graduate Programmer
Member
744 Points
244 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
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
Star
9893 Points
1291 Posts
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.
Member
730 Points
544 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
Star
9893 Points
1291 Posts
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
Member
730 Points
544 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.
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
Star
9893 Points
1291 Posts
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.
All-Star
52302 Points
15573 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