Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IIF IsNull problem

Status
Not open for further replies.
liltechy

liltechy

Programmer
May 17, 2002
145
US
In my report I have fields called Mon, Tue and so on. In the detail section of my report I want to print an X instead of the word. Here is my IIF statement that is not
working:

IIF(IsNull([Mon],"","X")

Why is this not working?


liltechy

 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
504
dhookom
dhookom
soloracer
  • Locked
  • Question
Problem using report recordsource values within report events. Error 2427 1
Replies
17
Views
384
soloracer
soloracer
Kennelbloke
  • Locked
  • Question
Problems with image on report 1
Replies
8
Views
280
dhookom
dhookom
lameid
  • Locked
  • Question
The Never shrinking whitespace problem 1
Replies
6
Views
171
lameid
lameid
Triacona
  • Locked
  • Question
count(iif,iif,value) is this and if? if so how do I do or if
Replies
2
Views
146
Triacona
Triacona

Part and Inventory Search

Sponsor

Back
Top