SELECT * FROM Client WHERE client.DateApp=sdate INTO TABLE apprreportWhich will get you all the records that match the value of sdate in the field DateApp. BTW, I would suggest that use select into a cursor instead of a table as the cursor will be cleaned up by VFP automatically when you close it where as the TABLE will hang around taking up disk space until you manually delete it.
SELECT * FROM Client WHERE client.DateApp >= sdate AND client.DateApp <= edate INTO CURSOR apprreportYou do not need to USE the table for your select explicitly, the SELECT command will open the table for you.
SELECT * FROM Client WHERE client.DateApp >= sdate AND client.DateApp <= edate INTO CURSOR apprreport IF _TALLY=0 MessageBox("no records to display") ELSE MessageBox("ken>all") ENDIF