Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cblgi
Starting Member
3 Posts |
 Posted - 2002-09-16 : 12:41:46
|
| I'm doing a nested iif query. When I try to run it, I get the error msg. "Undefined function 'table.field' in expression. This happens after the iif portion (actually in WHERE). Access Help says that this error msg means, "You've bound a control on a data access page to a calculated field that uses a function that isn't supported on data access pages." I don't think I created a data access page. Does this happen automatically? How can I get around it?ThanksB. Johnston |
|
|
JozzaTheWick
Starting Member
16 Posts |
Posted - 2002-10-09 : 13:24:24
|
| Can you post the query for us please?I'd also suggest breaking down the query if possible, perhaps first running the nested part & checking that that works. Then you could add in fields one at a time to see exactly what part of the query is causing the problem.J. |
 |
|
|
|
|
|
Undefined function?