View Single Post
  #15  
Old January 20th, 2010, 04:59 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Tables and relationships?

Tom

I misunderstood. I thought the "Single" data type was one that offered
considerably more precision than "Currency".

Regards

Jeff

"Tom van Stiphout" wrote in message
...
On Tue, 19 Jan 2010 09:10:35 -0800, "Jeff Boyce"
wrote:

Usually yes, I am a big proponent of using the smallest and most
accurate data type. But I think this is a justifyable exception: we
want only a single Quantity field, and it can hold the number of beds
donated, or gallons of drinking water, or yards of linnen, etc.

-Tom.
Microsoft Access MVP


Tom

As an alternative to Single, do you find it useful to use the "Currency"
data type?

Regards

Jeff Boyce
Microsoft Access MVP