Problem with Expression in Conversion

[S Jackson]

I have this expression in a report in my Access 2k db that will not work
when I convert the db to Access 97. I get a message when I try to access
the report in 97 that Microsoft does not understand the data contained in
report:

=IIf([Representative] Is Null,[CaseName],[Representative])

When I delete the text boxes that have an expression like the one above (If
statement) and then convert the report, the report will open in 97. I tried
putting that expression into newly created text boxes on the 97 report, but
the expression returns a 0 instead of what it is suppose to return.

Please help - deadline is today!

TIA
S. Jackson

 

[Roger Carlson]

It should be:
=IIf(IsNull([Representative]),[CaseName],[Representative])

In anything outside of SQL, you need to use IsNull( ) to test for "nullness"

 

[S Jackson]

Thanks!

S. Jackson

It should be:
=IIf(IsNull([Representative]),[CaseName],[Representative])

In anything outside of SQL, you need to use IsNull( ) to test for "nullness"

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

I have this expression in a report in my Access 2k db that will not work
when I convert the db to Access 97. I get a message when I try to access
the report in 97 that Microsoft does not understand the data contained in
report:

=IIf([Representative] Is Null,[CaseName],[Representative])

When I delete the text boxes that have an expression like the one above (If
statement) and then convert the report, the report will open in 97. I tried
putting that expression into newly created text boxes on the 97 report, but
the expression returns a 0 instead of what it is suppose to return.

Please help - deadline is today!

TIA
S. Jackson