This is an untested suggestion, but here goes: Access *subfile0 Subfile subfile1 keep if desc1 > "" include PO#,Line#, Desc1 Subfile subfile2 keep if desc2 > "" include PO#,Line#,Desc2