>CREATE CURSOR MyTable (transitNo C(10), region C(2)) >INSERT INTO MyTable VALUES('00001','NY') >INSERT INTO MyTable VALUES('00001','CA') >INSERT INTO MyTable VALUES('00001','FL') >INSERT INTO MyTable VALUES('00001','CO') > >INSERT INTO MyTable VALUES('00002','CA') >INSERT INTO MyTable VALUES('00002','NY') >INSERT INTO MyTable VALUES('00002','WA') && I changed this just for testing >INSERT INTO MyTable VALUES('00002','CO') > >SELECT DISTINCT region FROM MyTable INTO CURSOR crsDistReg >lcSelect = [SELECT TransitNo] >SELECT crsDistReg >SCAN > lcSelect = lcSelect + [, MAX(IIF(Region = ']+Region+[','Yes','No ')) AS ]+Region >ENDSCAN >lcSelect = lcSelect +; > [ FROM MyTable GROUP BY TransitNo INTO CURSOR crsXTab] >&lcSelect >BROWSE NORMAL >Boris,