I'd suggest that you take a look at the Microsoft Access Help Data Type Summary. That will let you know the storage size and range of each type and allow you to make the appropriate choice based on your needs.
HTH, Mitch --- 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=12ht3p8fk/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124896718/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</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/
