Microsoft Access - Calculated fields? - Asked By Aaron Stockton on 15-Oct-12 03:23 AM

I'm wanting to create a field in a table that calculates "=2.0*Exp(-0.450+0.987*ln([Drought Factor])-0.0345*[Relative Humidity (%)]+0.0338*[Temperature (Degrees)]+0.0234*[Speed (km/h)])"

though I have read that tables may not be the best for this, how would i do this in a query?

Hope someone can help
Pat Hartman replied to Aaron Stockton on 30-Dec-12 06:46 PM
Select fld1, fld2, 2.0*Exp(-0.450+0.987*ln([Drought Factor])-0.0345*[Relative Humidity (%)]+0.0338*[Temperature (Degrees)]+0.0234*[Speed (km/h)]) as fld3, fld4, ....
From yourTable