Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

formula in MS access

2 views
Skip to first unread message

Wije

unread,
Aug 17, 2009, 9:38:02 AM8/17/09
to
How to I perform the following Excel formula in access?

IF(A25=L3,B25,B24)

Please help

Paul S. Ganney

unread,
Aug 18, 2009, 4:51:37 AM8/18/09
to
You need the immediate if function, iif().
e.g. IIf("[Freight]>50",1,0)

Paul.

0 new messages