View Single Post
  #4 (permalink)  
Old October 31st, 2003, 12:16 PM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Quote:
quote:Originally posted by fastcorvette
 It turns out that I had to put the zero in glitches in order for it to work.

IIF(PricePer > '0', (Cost/PricePer), 0)
Glitches? :) I've heard "single quotes" and "apostrophes" but never "glitches". I'll have to remember that one.

If you have to put glitches on the zeroes that means that your Cost/PricePer field is a text field. Odd... shouldn't that be a number, in which case you wouldn't need the glitches.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division