Function problem in Access 2010

[hannlapp]

hi.

I have 2 databases. Both have the same table. I make a query and place in there function ucase([fieldname]).

Firsta database is working correctly but another way do not accept that (or many other) function at all.

How it is possible!!

hanski

 

[gemma-the-husky]

possibly a "references" problem.

 

[RainLover]

possibly a "references" problem.

I didn't think that queries used References unless they call a UDF.

 

[RainLover]

Hanski

Please post the SQL of the query that works and the one that does not work.

 

[hannlapp]

Hi.

Could it be some language prombelm because I changed something in the region settingns and now it seems to be working ok?

But I´ll be back if it comes up again..thanks.

hanski

 

[RainLover]

Thanks for letting us know.