Sorry for the rookie question.
Two calculations issues.
1. In Excel I'm able to do a uniformity calculation with (Smax-Smin)/Ave(S1-S9)*100, works great. In Access I've built a query and can get the Smax and Smin values of the data set but for the life of me I'm unable to figure out the rest to get the final uniformity in my Access table.
2. In Excel I have a lookup function, Lookup (Temp,{16, 17, 18, 19},{0.84,0.863,0.888,0.913}). The results of this lookup ("C") is used in another calculation, SNR=(Sm/Nav)*C. Any thoughts on how I can put this one together in an Access table?
Thanks