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