View Single Post
  #7 (permalink)  
Old April 10th, 2004, 12:26 AM
mateenmohd mateenmohd is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: abu dbabi, , United Arab Emirates.
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks for your response.

I put this code on the format, it give syntax error
Please guide me how can iif function

or

select case true
 CASE aposit = 'Sr. Resident Engineer'
                txtValue = 1
  CASE aposit = ''Resident Engineer'
                txtvalue = 2
  case . . . . .
END SELECT


in the Access Report ?

Regards.

Mateen


Quote:
quote:Originally posted by sal
 Straight from access help

IIf(IsNull([UnitPrice]), 0, [UnitPrice])
Changes a Null value to a zero (0) in the UnitPrice field

_____________________

You would have to nest it quite a bit.

But if you use this, you will be slowing down your processes by not using SQL Server engine.

Or you could send the values to the report without the case statement and put this code on the format event of the report.

select case true
CASE aposit = 'Sr. Resident Engineer'
                txtValue = 1
CASE aposit = ''Resident Engineer'
                txtvalue = 2
case . . . . .
END SELECT

that way you do not have to use Jet.



Sal
Reply With Quote