Access

D

D.A.Stellmach

I work at a company that produces there product in Ln. Ft. is there a way in
access to enter data as "10' 2"" or even the equilivent "10.17" and have it
able to calculate a sum for the entries. I have it set up now that the entry
is a number I have selected all of the formats but it is unable to display
them correctly and always wants to do a count instead of sum.
 
L

Larry Linson

D.A.Stellmach said:
I work at a company that produces there
product in Ln. Ft. is there a way in
access to enter data as "10' 2"" or even
the equilivent "10.17" and have it
able to calculate a sum for the entries.
I have it set up now that the entry
is a number I have selected all of the
formats but it is unable to display
them correctly and always wants to do
a count instead of sum.
Click to expand...

Just what do you mean by "unable to display them correctly" and "always
wants to do a count instead of a sum"? There are several "number" data
types, and none, in my experience, "cannot be displayed correctly" nor does
Access "choose" or "desire" to create either counts or sums.

How have you defined the number in your table? That is where you need to
start.

On a Form, you can have separate controls into which you enter Feet and
Inches, then calculate and save the number as a Single or Double precision
floating point value. Just where and how you do that will depend on details
of what you wish to do.

Larry Linson
Microsoft Office Access MVP
 
Top