One solution is MAXV = DCOUNT(FXI,@VM)
FOR I = MAXV TO 1 STEP -1 IF FXI<1,I> = '' THEN DEL FXI<1,I> NEXT I This handles embedded nulls as well as leading and trailing nulls. This would also give you a value if there are associated fields that would need to be removed. Rich Richard Sammartino Systems Analyst School District of Philadelphia 440 N Broad Street Philadelphia, PA 19130 Phone (215) 400-5086 Fax (215) 400-4411 ----- Original Message ----- From: "Garry Smith" <[email protected]> To: "U2 Users List" <[email protected]> Sent: Friday, January 28, 2011 7:29:48 PM Subject: [U2] How to Clear Empty VM marks in Field 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 TIA Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
