aggregate functions in web access queries

[ramaa46]

Hello,
I have created and published MS-Access database on sharepoint. aggregate function cannot be used in web quires.
I have used web reports to get required results.
Now I am able to get the data in access , but when I check the same in Web Browser it shows "#Error". But it sometime shows the data. And when it show the data correctly i can able to export to PDF but not able to export to excel.

[zmbd]

and your question is?

You'll find that a lot things you can do for a desktop access application breaks as soon as you go to the sharepoint server.
Read thru this: Access 2010: How to write expressions for Web queries, forms, and reports