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)?