Hi all,

I posted this earlier in Programming without response. So I thought I'd try
here.

I'm reverting back to Access 97 and running into a problem with the app and
the use of CurrentDB.OpenRecordset.

I am submitting a SQL statement for the domain which is where the problem
exists. In the SQL statment I am using the function Nz() which works fine
when viewing a queries in the query window. However, when I try to submit
the same SQL to OpenRecordset, I get an error telling me that the function
'Nz' is undefined.

It's been a while since I worked with A97, but I don't recall ever having
such problems. Is there a reference or otherwise I might be missing here?

Thanks in advance...
MPM

Figured this one out... It was a case sensitivity problem that 2000 and later
ignore. Hope this is helpful to anyone else...

Best!

"MPM1100" wrote:

> Hi all,
>
> I posted this earlier in Programming without response. So I thought I'd try
> here.
>
> I'm reverting back to Access 97 and running into a problem with the app and
> the use of CurrentDB.OpenRecordset.
>
> I am submitting a SQL statement for the domain which is where the problem
> exists. In the SQL statment I am using the function Nz() which works fine
> when viewing a queries in the query window. However, when I try to submit
> the same SQL to OpenRecordset, I get an error telling me that the function
> 'Nz' is undefined.
>
> It's been a while since I worked with A97, but I don't recall ever having
> such problems. Is there a reference or otherwise I might be missing here?
>
> Thanks in advance...
> MPM
>