recipe conversion lookup

[timbits35]

Hi,

I am making a recipe database. I have the ingredient quantities as a number
field and for calculation purposes I have to enter them as single (so I can
allow the user to double or half the recipe). However for display purposes on
reports, I would like to have 0.5 show up as 1/2, .667 show up as 1/3 i.e
display the fractions. I am a little rusty on how to do this. Do I create a
lookup table? And if so I don't remember how.


Thank you

 

[Mr. B]

Hi,

I am making a recipe database. I have the ingredient quantities as a number
field and for calculation purposes I have to enter them as single (so I can
allow the user to double or half the recipe). However for display purposes on
reports, I would like to have 0.5 show up as 1/2, .667 show up as 1/3 i.e
display the fractions. I am a little rusty on how to do this. Do I create a
lookup table? And if so I don't remember how.

Thank you

Take a look at this from a previous post. It might be what you need.

http://groups.google.com/group/micr...+decimal+to+fractions&rnum=1#a60cca9521780de4

HTH

Mr. B

 

[timbits35 via AccessMonster.com]

Hi,

I am looking for something a little simpler.

In a recipe there are only a few different fractions that never change. Like
1/2 cup, 1/3 cup, 1/4 cup 2/3 cup etc. So I don't need any complicated
conversions. Can anyone guide me on an easy way to do this.

Thank you

LM