First as an introduction you may be receiveing many "uninformed" questions from me, what with Budget cuts our group of programmers have been tasked to rewrite all of our MIS in Visual FoxPro from DbaseV, without benefit of any formal training....so here goes the first one:
I have read as many manuals as I can find and have producted the following SQL progarm to select my data (query) and feed it to a report , but the final output looks as as if no query/selection has occurred....help:

CLOSE DATAB
SELECT Reforg.code, Reforg.dept, Reforg.ccloc, Reforg.ccadmin,;
  Reforg.divtitle, Reforg.activeflag, Reforg.bldg, Reforg.delflag;
 FROM reforg;
 WHERE Reforg.activeflag = "Y";
   AND Reforg.delflag = "N";
 ORDER BY Reforg.code;
 INTO CURSOR Refcmdorg
IF _TALLY < 1
   MESSAGEBOX ("No Records selected, No report Generated")
   USE
   CLOSE DATAB
   RETURN
ENDIF   
SELECT Refcmdorg
REPORT FORM refcmdorg.frx NOCONSOLE PREVIEW
USE
CLOSE DATAB
RETURN

Any help is most appreciated! Thanks