>>>Craig, a>
>Craig, I should rephrase my quest. At least 1 of the 12 fields can't be blank.
>(char(5)), So if ALL 12 are = " ", I want to disregard the record.
SET FILTER TO ALLTRIM(statmnt_dt + stat_date1 + stat_date2 + stat_date3 ;
+ stat_date4 + stat_date5 + stat_date6 + stat_date7 + stat_date8 ;
+ stat_date9 + stat_dat10 + stat_dat11 stat_dat12) == ""
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer