How can I write an expression....

  • Thread starter MichelleM via AccessMonster.com
  • Start date
M

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!
 
M

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!
Click to expand...
 
S

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
[email protected]
 
K

KARL DEWEY

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

--
Build a little, test a little.


MichelleM via AccessMonster.com said:
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!
Click to expand...

--



.
Click to expand...
 
Top