View Single Post
  #10  
Old January 19th, 2010, 04:17 AM posted to microsoft.public.access.tablesdbdesign
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default Tables and relationships?

On Sun, 17 Jan 2010 13:39:01 -0800, awsmitty
wrote:

I mean that this table will have a field named Quantity, which is of
datatype Single, and it is a required field.
This will allow you to record how many items of a particular kind
there were in one particular donation. I first thought to use Integer
for the data type, but what if someone donated $12.50? Maybe your item
is "money", and your quantity is 12.5.

-Tom.
Microsoft Access MVP



Tom.
At the end of the forth paragraph, you mention"quantity single required". I
have to ask, what do you mean?