If you are dealing with currency that goes beyond 4 decimals, then I definitely recommend using double as the field type. Access has a limitation in the currency field to not read values beyond 4 decimals. I work with a lot of contractors. Big bundles of wire contractors buy can be priced to the 5th decimal, so currency doesn't work. TJ
--- 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 > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hqun1f2/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124856597/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/
