I have fields declared as double especially when I know that the field will be large. Access will automatically increase the field from single to double if the field yoe set to single as surpassed the limit.
A.T. --- In [email protected], "Hairydoris" <[EMAIL PROTECTED]> wrote: > Hello All > > Please confirm my understanding of data types particularly single and > double. A single has a range of approximately -3.4e38 to 3.4e38 and a > double -1.8e308 to 1.8e308. I am not exactly sure of the number of > decimal places each are acurate to but i'm asumming it's "alot" for > both. > > So now the question - given that most applications that i deal with > aren't splitting an atom and aren't dealing witn my bank account that > has 10^38 million dollars in it, and that i have many tables with a > feew million rows, for DB size purposes, i should not have any field > declared as a double. > > Would you all agree??? > > thanks > > Peter ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hh7ljjh/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124840808/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
