Rob, There is a function called "null to zero" which will do the job. It doesn't appear in the function list of the formula builder, but you can still access it via the GUI.
Say you had a variable "foo" that you wanted to fix: 1. Right click on foo (or select edit... fill from the menu) 2. Type "NullToZero(foo)" into the formula box. 3. Click OK. P.S. To save a few keystrokes, you can also use NZ(foo). P.P.S. Caliper had a "Zero to Null" macro up on the support website. It probably wouldn't be hard to modify it to go the other way if you have a lot of fields to fix. --- In [email protected], "Rob Strangia" <[EMAIL PROTECTED]> wrote: > > What is the best way in Maptitude 5.0 to convert all of the null integer > values in a table to 0? I seem to remember being able to do that > modifying the fields containing them into real numbers, than back to > integers. However, this method does not seem to work in 5.0. > > > > Thanks in Advance for any help. > > > > Rob > > > > Robert M. Strangia, GISP > > GIS Administrator > > > > Georgia Legislative Redistricting Services Office > > 18 Capitol Sq. SW, Suite 407 COB > > Atlanta, GA 30334 > ------------------------------------ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Maptitude/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/Maptitude/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
