View Single Post
  #2  
Old December 15th, 2006, 05:33 PM posted to microsoft.public.access.forms
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default Stdev in forms(Please, help!)

The StDev function can only be used in a query, not in VBA.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Gostap via AccessMonster.com" u29357@uwe wrote in message
news:6acd7bbd2e811@uwe...
I wonder, if itīs possible to have a Stdev function in forms(in detail
part)

I have 3 unbound fields in the form and i want calculate the Stdev of
these 3
fields. Is it possible i detail section?
The three fields and the Stdev result should be on the same post. I have
tried this: =Stdev([field1]+[field2]+[field3]) and also several other
solutions but it doesīnt work. Is it possible?

Grateful newbie

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1