cWhere = "BETWEEN(WeekOf, {01/01/1990},{12/31/2004})" SELECT DocId, BoId, BoIdBase, RecType, OrdQty, Gross, StatName, ClientId, BInit,; WeekOf, DStat_Net, DClnt_Net,DLComm, 0.00 AS NumCleared; FROM LineItems; WHERE &cWhere; INTO TABLE LineTempNotice BrokerId is no longer there. I will filter it out later.
>CREATE CURSOR TempBrok (BrokerID C(2)) -- or whatever the length is >INSERT INTO TempBrok VALUES ('MC') >INSERT INTO TempBrok VALUES ('') > > > >SELECT DocId, BoId, BoIdBase, RecType, OrdQty, Gross, StatName, ClientId, BInit,; > WeekOf, DStat_Net, DClnt_Net,DLComm, 0.00 AS NumCleared; > FROM LineItems; > JOIN TempBrok ON TempBrok.BrokerID = LineItems.BrokerID > WHERE (your date clause) > INTO TABLE LineTemp >>