28-Jul-2006, 08:22 AM
|  | Guest | | | | | | | | | | Re: The percent field in my Access 2000 changes all decimals to 0%
What is the Field Size of the field in the table. If it is an Integer or Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11584
Long, it is probably being converted to zero since those data types can't
have a decimal. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11584
--
Wayne Morgan
MS Access MVP
"jlpirozzi" wrote in message
news:00B58891-E08E-4DD7-A25C-1740BA36F285@microsoft.com...
> In my database, I have a field for % complete. It is defined in a table
> as a
> %, but it will not convert a decimal to the correct percent. 1 changes to
> 100%, 10 to 1000%, but .10, .20, .25 etc changes to 0%
| 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Active Discussions | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |
