How can I write an expression....

[MichelleM via AccessMonster.com]

I want to write an expression in a report that states

If [DisplayAnswer] is blank, then [QuestionText] should be blank.

DisplayAnswer is linked to any notes entered and if there are not any notes
entered, I do not want to see the information in QuestionText.

Thanks for any help!

 

[MichelleM via AccessMonster.com]

I forgot to add, if there are notes in DisplayAnswer, then I want
QuestionText to stay as is.

I want to write an expression in a report that states

If [DisplayAnswer] is blank, then [QuestionText] should be blank.

DisplayAnswer is linked to any notes entered and if there are not any notes
entered, I do not want to see the information in QuestionText.

Thanks for any help!

 

[Steve]

Base your report on a query that includes the fields you want to see in the
report. Set tne criteria for Display to Is Not Null so you only get the
questions that have answers.

Steve
(e-mail address removed)

 

[MichelleM via AccessMonster.com]

That worked! Thank you so much!

Base your report on a query that includes the fields you want to see in the
report. Set tne criteria for Display to Is Not Null so you only get the
questions that have answers.

Steve
(e-mail address removed)

I want to write an expression in a report that states

[quoted text clipped - 5 lines]

Thanks for any help!

 

[KARL DEWEY]

Try this --
QuestionText_1: IIF([DisplayAnswer] Is Null OR [DisplayAnswer] ="", "",
(QuestionText])

--
Build a little, test a little.

I forgot to add, if there are notes in DisplayAnswer, then I want
QuestionText to stay as is.

I want to write an expression in a report that states

If [DisplayAnswer] is blank, then [QuestionText] should be blank.

DisplayAnswer is linked to any notes entered and if there are not any notes
entered, I do not want to see the information in QuestionText.

Thanks for any help!

--



.