S spowers21 Registered User. Local time Today, 02:11 Joined Mar 28, 2002 Messages 49 Aug 26, 2002 #1 Is anyone out there using Access to calculate sigma values? or does anyone how to use the following Excel formula in VBA NORMSINV(1-([field1]/[field2]))+1.5. Any help would be appreciated.
Is anyone out there using Access to calculate sigma values? or does anyone how to use the following Excel formula in VBA NORMSINV(1-([field1]/[field2]))+1.5. Any help would be appreciated.
R RV Registered User. Local time Today, 07:11 Joined Feb 8, 2002 Messages 1,115 Aug 26, 2002 #2 Look up these statistical functions in Access: DStDev and DStDevP HTH, RV
S spowers21 Registered User. Local time Today, 02:11 Joined Mar 28, 2002 Messages 49 Aug 26, 2002 #3 Thanks, I'll give it a try.