By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,234 Members | 1,844 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,234 IT Pros & Developers. It's quick & easy.

access 97 to access 2003: query builder question

P: n/a
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
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.