How to get around Undefined function 'FldVal' in expression in MSAccess

See more:

C#

MS-Access

I'm trying to build a report that builds a pdf file. I'm using a console app that uses MS Access as database. Within the Access database I call a query that contains a user function that performs calculations. That where the issue comes in. Every time I run the console app I get the following error message:

Undefined function 'FldVal' in expression

The query containing the 'FldVal' function runs perfectly from within Access but not from the console app. Here is the code that blows-up:

public static DataSet Get941Data(string rpt, int year, string qtr)
{
    DataSet ds = new DataSet();
    string CommandText = "SELECT  * FROM  qry941PDF";

    using (OleDbConnection connection = new OleDbConnection(DigiplexPDFs.AppSettings.GetAccessPathConnectionString()))
    {
        using (OleDbCommand cmd = new OleDbCommand(CommandText, connection))
        {
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.AddWithValue("qtr", qtr);
            cmd.Parameters.AddWithValue("rpt", rpt + year);
            cmd.Parameters.AddWithValue("year", year);

            connection.Open();

            OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);

            adapter.Fill(ds);

            return ds;
        }
    }
}

It crashes on the adapter.Fill(ds) line. Somehow I'm not able to run this query with a function. Is there anyway around this?

CORRECTION: If the above is incorrect I'd like a different approach. Is there a Stored Procedure type call to Access available where I can pass parameters?