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