Prev: I am officially SPOOKED by Access 2003 behavior.......
Next: Control of allowedits when changing views
From: (PeteCresswell) on 12 Aug 2010 13:55 For dollar/cents amounts in the billions I've been going on the assumption that Double is the only game in town. Ditto share amounts in the billions with up to 4 decimal places. Bad assumptions? -- PeteCresswell
From: David W. Fenton on 12 Aug 2010 20:00 "(PeteCresswell)" <x(a)y.Invalid> wrote in news:l8d866920ehlg32thgcmkjmqr4m5emnrg3(a)4ax.com: > For dollar/cents amounts in the billions I've been going on the > assumption that Double is the only game in town. > > Ditto share amounts in the billions with up to 4 decimal places. > > Bad assumptions? Er, isn't currency going to be able to hold that, too? It's only the integer part that matters, right? According to the Access help file, the max for currency is over 922 trillion. If you have a client dealing in that kind of money, I wanna piece of the job! -- David W. Fenton http://www.dfenton.com/ contact via website only http://www.dfenton.com/DFA/
From: (PeteCresswell) on 13 Aug 2010 09:16 Per David W. Fenton: >Er, isn't currency going to be able to hold that, too? It's only the >integer part that matters, right? According to the Access help file, >the max for currency is over 922 trillion. > In 2003, the only types I see are: - Byte - Integer - Long Integer - Single - Double - Replication ID - Decimal I was thinking maybe decimal, but it seems like I've tried it before and ran into issues. >If you have a client dealing in that kind of money, I wanna piece of >the job! Big mutual fund outfits. It's good work in that I'm such a miniscule piece of such a humongous pie that they don't worry about the nickels and dimes at billing time. OTOH, mess up and put something bad into production and there's Hell to pay. -- PeteCresswell
From: John Spencer on 13 Aug 2010 10:02 Currency is a separate choice for field type. Those are all the number field types. Currency is really a number field (Decimal with four places after the decimal point) Date(time) fields are another special case of a number (double) with the integer portion representing the date and the decimal portion representing the time of day. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County (PeteCresswell) wrote: > Per David W. Fenton: >> Er, isn't currency going to be able to hold that, too? It's only the >> integer part that matters, right? According to the Access help file, >> the max for currency is over 922 trillion. >> > > > In 2003, the only types I see are: > - Byte > - Integer > - Long Integer > - Single > - Double > - Replication ID > - Decimal > > I was thinking maybe decimal, but it seems like I've tried it > before and ran into issues. > >> If you have a client dealing in that kind of money, I wanna piece of >> the job! > > Big mutual fund outfits. > > It's good work in that I'm such a miniscule piece of such a > humongous pie that they don't worry about the nickels and dimes > at billing time. > > OTOH, mess up and put something bad into production and there's > Hell to pay.
From: (PeteCresswell) on 13 Aug 2010 20:42
Per John Spencer: >Those are all the number field types. > >Currency is really a number field (Decimal with four places after the decimal >point) Is currency subject to the floating-point arithmetic issues where, if you query a few thousand records whose amounts actually net out to zero, you can get something like .00000000043656 instead of zero? -- PeteCresswell |