[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference bump::msaccess

Title:MSACCESS
Moderator:BUMP::HONER
Created:Tue Dec 01 1992
Last Modified:Mon Jun 02 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1661
Total number of notes:6339

1633.0. "Signed Numeric conversion" by DEMAND::HERSEY () Tue Feb 11 1997 15:13

    
    	Hi,
    
    		Does anyone know if notes 106, which talks abount signed
    		numeric conversion into ACCESS was ever addressed by
    		Micro-Soft, and if not does anyone know a work-around?
    
    	Thanks,
    
    		John
T.RTitleUserPersonal
Name		DateLines
1633.1Must have slipped awayNSIC00::KLERKThunderbirds are GoTue Feb 11 1997 16:277
 I don't think it ever made it into the product.

 You'll have to somehow convert the numbers yourself, e.g. import them
 as text and somehow convert those into true numbers. Or if possible
 have it done at the source rather than in Access.

 Theo
1633.2emptyDEMAND::HERSEYThu Feb 13 1997 10:109
    Hi Theo,
    
    	Thanks for the reply.  I've tried what you said, import them as
    	text and convert.  There appears to be no way to successfully
    	convert them, I believe I've used every combination available in
    	the ACCESS arsenal and came up empty.  We will have to change it
    	at the source which is always fun.
    
    John