AVG, STDEV function doesn't work in adp

  • Thread starter Thread starter X-Men
  • Start date Start date
X

X-Men

I want to use aggregate functions in an access data project.
However, in view designer it only has functions such as Min, Max, Count,
etc, but not the AVG, STDEV that I need. The system throw me an error when I
try to force using AVG and STDEV function like in SQL query.
Does anyone know what is wrong?

Thanks
 
Try opening the northwind ADP sample and check out the view named:

"Products Above Average Price"

If it fails to run, you may have something wrong with your Sql
installation...

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#Error when using stDev in query 1
using a conditional in STDEV function 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Display formula Excel uses for internal functions (STDEV...) 1
Comparing % Differences From in Pivot Tables 2
Add a function to the status bar? 1
STDEV function in VB scritp for excel 4
call function in query 3

Back
Top