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
 
Back
Top