View Single Post
  #13  
Old January 19th, 2010, 05:10 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Tables and relationships?

Tom

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

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Tom van Stiphout" wrote in message
...
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?