hi-
this function IDSpecialCases works great in access 97 in the query
builder but why doesn't it work in access 2003? would does anyone have
any wild guesses? is it a problem with the dao reference?
error message: undefined function 'IDSpecialCases' in expression.
(Undefined function <name> in expression. (Error 3085)
You entered an SQL expression that includes a Function procedure name
that cannot be recognized. Make sure the function exists, that it can
be used in SQL expressions, or check the expression to make sure you
entered the name correctly.)
OD Analysis: IIf(IDSpecialCases([qryBMIssueODReport]![Loan_Shortname],[qryBMIssueODReport]![DB],[qryBMIssueODReport]![LoanAccount])<>"not
found",IDSpecialCases([qryBMIssueODReport]![Loan_Shortname],[qryBMIssueODReport]![DB],[qryBMIssueODReport]![LoanAccount]),Compare_result([qryCombinedPANDC1]![Lnx_CashBalL],[qryWire_Control-HeldWires]![AMT],[qryBMChecksAmts]![Ck
Amt],[Fully Collected?]))
thanks in advance - jung