Do not use value!

[ChristopherL]

Hi!
I want to make a copy table where I copy all the values from a database and filter out the values that I want.

In one of the columns theres a number value that can't be changed manually to text, for that value I want to convert it and ignore the null values.

So I only want to show the values that are visible.

I tried with TRY: IIf([PQ_OPTIONVAL_D]=Null;0;Val([PQ_OPTIONVAL_D]))



But what can I use instead of "0" to just ignore it?
Right now it just shows #error but I dont even want the record to show.

Many thanks
/ C

[June7]

=Null won't work, ever. Review: http://allenbrowne.com/casu-12.html see Error 5.

To exclude all records where PQ_OPTIONVAL_D is Null, just restrict the query to select records that are not Null - in the Criteria row under PQ_OPTIONVAL_D: Not Is Null

[ChristopherL]

=Null won't work, ever. Review: http://allenbrowne.com/casu-12.html see Error 5.

To exclude all records where PQ_OPTIONVAL_D is Null, just restrict the query to select records that are not Null - in the Criteria row under PQ_OPTIONVAL_D: Not Is Null

Many thanks, however since I am going to use iff statement to change the text to number if its not null? How do I add that in an iif statement?

[June7]

Try (no IIf):

Val(Nz([PQ_OPTIONVAL_D],0))

[ChristopherL]

Try (no IIf):

Val(Nz([PQ_OPTIONVAL_D],0))

Worked perfectly!!
Thanks!