Can a query do all that?

[Guest]

I am trying to set up a database that can pull the nutrient content of
formulas from a table and multiply the different nutrients contents with the
volume of formula recevied and then multiply with a factor for the
concentration of formula the patient receives. So far I have a table set up
with formula nutrient information and another table with sample patients and
their information. I have roughed out a form for the dietitian to select a
patient's name from the list of patients, to select a formula from the list
of formulas, and to select the concentration of formula (i.e. full strength,
3/4 strength, 1/2 strength). I was hoping that a query could pull the
nutrient content of the formula selected and then multiply the content with
the formula volume and then by a factor for the formula concentration. Can
one query do all of this? Does this sound do-able?
Should I set up a table with the different formula concentrations of formula
that are used and include the factors that the formula should be multiplied
with for those different formula concentrations (1.0, 0.75, 0.5, etc)?
Thanks for any advice you can give!

 

[Jeff Boyce]

Febra

What you described sounds like primarily calculations -- is there a business
reason, beyond the calculations, for you to be using a relational database
(Access) rather than a spreadsheet?

By the way, you've posted a "how do I do this in a query?" question in a
newsgroup that deals with table design. You'd probably get more responses
posting in the queries newsgroup.