AVG, STDEV function doesn't work in adp

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

X-Men - 16 Jan 2004 19:42 GMT

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

Reply to this Message

Jerry Boone - 16 Jan 2004 22:39 GMT

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...

Signature

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

> I want to use aggregate functions in an access data project.
> However, in view designer it only has functions such as Min, Max, Count,
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message