Value in a Queary

[jakehale]

I have my queary set up and one of the colums are date's,,,if i don't have a date for the colum i would a "word" to appear, like "emtpy"

Can this be done? i was reading about the Nz function, and when i can get it to work then the whole queary comes out blank if i cant get it to work then i get syntac error


thanks

 

[FoFa]

In QBE it would as such:
ColAlias: IIF(isnull([MyDate]),"Empty",[MyDate])

You may have to format the date so it comes out as a string to match "Empty" (like data types) depending on what you are doing.

 

[jakehale]

What its doing

when i enter IIF(isnull([Expr19]),"Empty",[Expr19]) in criteria box of the queary... the result is, that if the feild is empty then the whole record dont show up at all..

 

[dcx693]

jakehale, you need to put the expression in the Field: line, not the Criteria: line, that's why Fofa put the ColAlias: prefix in front of it, to name the column "ColAlias". You can substitute a more appropriate name.

 

[jakehale]

thanks

Thanks folks,,,

worked like a champ!!!!

Until next time....................