View Single Post
  #6 (permalink)  
Old April 8th, 2004, 07:01 PM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

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 . . . . .

that way you do not have to use Jet.

Reply With Quote