Hi
I have developed a project which is using Access as Db, evertyhing is going smooth, the problem is that in one of user tables i have a lot of numeric data, for which i have to calculte an average value, whenever the information is requested.
The numeric data is updated regularly, so have to calculate the average on run time, but since the records have gone upto 10000, the processing is pretty slow.
I have solved such problems in SQL Server using Views, but in Acces i cant find any such thing. Ive looked at parameter queries, but they havent been much help either.
Can anybody suggest a better technique or apporach.
Thanks for your suggestion in advance
AS
Software Developer

How do you find average? Is that you parse through all the records and add them up and divide by number of records?

Did you try using AVG() function? Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

hi! actually i the numbers in multiple colums, that is in one row, against their username, ten numbers, i have to add these ten and get the average. Since the number of records incresed the processnig time has increased too, Any suggestions on this.
THanks for the previous reply..