I have a client who has converted an Access '97 Database to Access 2003. all seems to have gone well except...one query problem.
In 97 one of the queries used 'Is Null' to find nearly half of all items in a table. Now (in the 2003 converted db)the 'Is Null' criteria is only yielding 3 records.

Has anyone encountered this kind of situation? If so, how did you correct it?

Ron K

It may be that what Access 97 recognizes as Null, Access 2003 recognizes as empty, which is not null. So add

Or = ""

to your criteria and see if that works. If it is a number field, then add

Or = 0

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com

Thanks for the prompt response, mmcdonal!
The client was in class today so could not exercise your thought.
He will try it tomorrow.
Thanks, again.
RonK

Can you send the steps to convert db access 2007 to access 2003 ?

I try to convert by save as but it give message that
"you cannot save this database to earlier version format because It uses features that require the current files format"

How can convert the access 2007 db to access 2003?

Thanks
Mateen