AVG, STDEV function doesn't work in adp

[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

 

[Jerry Boone]

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