functions in queries

[villan60]

Can I use a function that returns a field name as a field name in a query?

I have written a function which selects the field and returns it but when I use it as a field in the query I get an error 'Undefined function in expression'

any ideas?

Thanks
dax

 

[Philly44]

Can you post the expression.

 

[Cagliostro]

you can use such type of functions only in making dinamic SQL

dim xxx as string
function yyy() as string
yyy = "name of a column"
end function

function zzz()
xxx = "select " + yyy + "from sometable"
docmd.runsql xxx
end function John Fill

ivfmd@mail.md