How To Do Percents ?

Jul 18, 2006

I have a table / Query that when I type in a product name it will pull up the product, specific weight (in grams) and the ingredients that are in it.
(see example below)
I want to be able to type in a percent and have it calculate the percent of the specific weight that is first shown, then show the results.

mycookies:
chocchip specific weight flour (type in percent) (show result)
chochip specific weight salt (type in percent) (show result)
chochip specific weight butter (type in percent) (show result)

I also need this to be able to do the same thing even if there is only one
ingredient for a cookie.

mycookies:
chocchip specific weight flour (type in percent) (show result)

I hope I have explained this good enough...thanks for your help !

(access 2003)

View Replies


ADVERTISEMENT

Calculating Percents

Sep 22, 2005

I have a table containing the following fields :
Sex(text), Age(numeric), sodium concentration(numeric).

I am trying to write a query which will return the percentage of male patients have a sodium concentration of a certain range (ex:120-130) out of the TOTAL number of patients.
I am able to count the number of events which fit the criteria but I cannot figure out a way to calculate the percentage part (unless i manually add a field in which I devide the count result by total number of patients).

Any ideas?
Thanks

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved