If you don't have to worry about associated fields and you're trying to clear null attributes or you want a count of the non-null attributes then trim is probably the easiest way (plus there are options to only clear leading,trailing,or all):
FXI = TRIM(FXI,@VM) Hth Colin Alfke Calgary, Canada -----Original Message----- From: Allen Egerton On 1/28/2011 7:29 PM, Garry Smith wrote: > FXI = 1ýý > > DCount(FXI,VM) returns 3 > Is there function to clear the blank value marks so that FXI = 1 and then DCOUNT would return 1 If your field is associated with any other fields, simply removing all value marks preceding null fields will potentially de-synchronize (is there such a word?) the relationships. That is, you can remove any trailing VMs, but not any embedded ones. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
