This is very confusing, I have developed an access database, the tables are linked to a text file which is updated each day. In a query I have entered: Week: Val(Format([Date],"ww")-1). The program works on 4 pc's in the department, but on other pc's with the same version of access and spec I am recieving an error. Function is not availible in expression in query expression Val(Format([Date],"ww")-1).
I created a new database on the pc that showed the error, entered the same expression into a query and it works.
Is there something in access(permissions etc.) that need to be changed? How do I solve this problem?