OK i have a web access 2010 database that i want to publish on sharepoint.

I created a form based on a table and included a text field which control source is an expression like this :

=Sum(IIf([Status]<>"Completed",1,0))



which works if i am in access but in sharepoint the same field shows a #Name?

if i use something simpler as =count([Status]) i get the number in access and in sharepoint. so two questions:

1. what is the possible problem?
2. how can i create soemthing like this (sum if ) using a web macro (so it would work in sharepoint)?