Undefined Function in expression

[carefully]

I have an Access query, qryA, which produces an output which includes a column 'season' e.g 1993/4 based on a function 'FX_Season' which does a date comparison.

Everything works fine in Access but when I attempt to set up
a CFQUERY utilizing qryA I get the error "Undefined function 'FX_Season' in expression"

Is there anyways round this. I don't want to have to make
an Access table based on qryA [sig][/sig]

 

[iza]

maybe it's a synonym problem : which username does coldfusion uses when it logges on your db ??
if not, maybe you should use <cfstoredproc ..> tag ! [sig][/sig]