IF Statement Help

[wfairbanks]

I have an IF statement to compare one column in an Access db to another column in the same Access db. Please tell me what I am doing wrong!

IIF([tabname.informix_pubtablesd17]<>[tabname.informix_pubtablesd]),1,0)

IF tabname is not equal to tabname give me a 1 else give me a 0.

 

[WildHare]

I'm not ABSOLUTELY certain on this, but I think you are missing a pair of brackets:

Try this:

IIF([tabname].[informix_pubtablesd17]<>[tabname].[informix_pubtablesd]),1,0)

IOW, the syntax is [table-name].[fieldname], not [tablename.fieldname]

I think...I've always done it that way, and otherwise, your expression looks ok...

jmh

Don't be sexist - Broads hate that!

Another free Access forum:

http://www.forumco.com/jmhare

More Access help stuff at

http://www.jmhare.com/wildhare.htm

 

[dhookom]

or
([tabname].[informix_pubtablesd17]=[tabname].[informix_pubtablesd]) + 1

Duane
MS Access MVP
Find out how to get great answers faq219-2884.