using parameters for calculations

  • Thread starter Thread starter c8tz
  • Start date Start date
C

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
 
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
 
For what purpose are you needing to store the information? Maybe append a
record to your Fertilizer Utilization records.
 
Back
Top