Access 2000 - Query runs on Win98 but not on Win2000

[dsmith910]

Hi

I have developed a database in Access 2000 running on Windows 98. The other user has Access 2000 but on Windows 2000.

I have a query which counts the number of clients per month in various areas of the business. In this query I have
Expr1:Format([RefRec],"yy-mm&quot to list the months in order showing the year first (a requirement of the boss!).

On my machine it works fine. On the other user's machine the query returns a fault message of Undefined function 'Format' in expression.

Anyone any ideas what's gone wrong or have any idea how to get round using that particular expression?

Doreen

 

[ctarr]

This usually occurs b/c the other PC's are running different versions of Access. Older versions don't have the same built-in functions as the newer version. But, since you said everyone was using Access2k then I'm not sure what the exact answer should be.

Is this a basic query or something done from VBA? If it's a query then go into design view and see if you can get the query to run. My bet is you won't be able to. I'd look in the query builder for a similar function and see if the Format function even exists.

Otherwise, you can try asking in one of the Microsoft: Access forums they have many more experts on this kind of problem.

Post back and I'll still try to help.

Craig

 

[dsmith910]

Hi Craig

Many thanks. As far as i can se only the Windows version is different - Access is the same. Its a basic query which runs fine on my machine but not on the other. Can you suggest another suitable forum for me to try? I haven't found another one which is anywhere near as good as this.

Doreen

 

[ctarr]

If you want post the query (SQL View or query builder) here. I can look at it for you.

Otherwise, search for forums and use the word "Access". You'll get four or five active forums.