A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Stdev in forms(Please, help!)



 
 
Thread Tools Display Modes
  #1  
Old December 15th, 2006, 04:27 PM posted to microsoft.public.access.forms
Gostap via AccessMonster.com
external usenet poster
 
Posts: 5
Default Stdev in forms(Please, help!)

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

  #2  
Old December 15th, 2006, 06: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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.