using parameters for calculations

[c8tz]

hi,

I need to do a query that uses parameters for getting the number of
trees and then using that parameter to calculate the fertilizer needed
for that year.

Hence:
Number of Trees:

Fertilizer = Number of Trees * ApplicationRate

I created a column in the query such with the following

Fertilizer: ApplicationRate*[NumberOfTrees]

This works ok. But I also need to store the NumberOfTrees Parameter.

Do I need to create a temp table ?

Please help -Thanks

 

[Jeff Boyce]

Why do you believe you need to store [Number of Trees]? Do you intend to
make additional use of that? For what? How often?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

For what purpose are you needing to store the information? Maybe append a
record to your Fertilizer Utilization records.