View Single Post
  #24  
Old July 5th, 2007, 02:16 PM posted to microsoft.public.access.forms
KevinKBM
external usenet poster
 
Posts: 14
Default how do i set access to use fractions and add/multiply them?

That would be a simple solution, however this will be used not only by the
workers here but by our clients when they come in to the office and place
orders on site.
and possibly on the road with our sales people.


"jrmask via AccessMonster.com" wrote:

I do this for corrugated sheets to fiqure board feet. I use fractions for the
calculations and taught my people to use them by suppling a conversion sheet.
Now they enter 1.75 for 1 3/4 inches or 5.625 for 5 5/8. Most do not have to
look at the conversion chart any longer. =([txtLenght] * [txtwidth]) /144



KevinKBM wrote:
going to be calculating board feet, the formula is WxL \ 144 (11 7/8 x 12 7/8
Divided by 144 and the rusult will be shown in a seprit text box . I can send
you the DB if that will help.

Show me how you are going to apply a measurement that includes fractions and
maybe I can help you from there. For example, your measurement is 125 5/8",

[quoted text clipped - 74 lines]
ba
able to add, multiply and divide them.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200706/1