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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IIF In Report Field

Status
Not open for further replies.
vr

vr

Programmer
Oct 14, 1999
54
US
Can anyone tell me what is wrong with this?

=IIf(IsNull([acctnumber]),[empnumber],[acctnumber])

I have this in the control source of a text box on a report. This is returning #Error in the preview of the report.

 
Sort by date Sort by votes
try this

=IIf([acctnumber] = is null),[empnumber],[acctnumber])

goofy I know
try it with a space and without

is null
isnull DougP, MCP

Visit my WEB site to see how Bar-codes can help you be more productive
 
Upvote 0 Downvote
Make sure that the name of the control is not AcctNumber or EmpNumber. If it is, you would get that #Error message.
Joe Miller
joe.miller@flotech.net
 
Upvote 0 Downvote
Thank you Doug and Joe. My control was named AcctNumber.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
964
renigar
renigar
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
1K
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
Bennie47250
  • Locked
  • Question
Report Crashes
Replies
2
Views
332
kray4660
kray4660
clevercat88
  • Locked
  • Question
Field in table will not filter - info update
Replies
0
Views
313
clevercat88
clevercat88

Part and Inventory Search

Sponsor

Back
Top