Search results for query: *

OK AFTER THINKING ABOUT IT I want to sort the file by highest to lowest(descending) score then code the top 10% records. The 10% is based on record number not on the score. Then code next tenth B,C,D...etc

YES alvechurchdata, I need to look at the entire score in the data file and code the top 10%/(1/10) of records based on score then code the next 10%/(1/10) records of the data based on score. Does this help?

I AM USING VFP 6.0 I have a data file with a Character field called TESTSCORE it contains whole number 100,99,98,97,96.....0 I would like to sort it in descending order by TESTSCORE then code in a different field A - for the top 10% B - for NEXT 10% C - for NEXT 10% D - for NEXT 10% E - for...

THANK FOR THE KNOWLEDGE IT WORKS PERFECTLY.

PERFORM A QUERY ON MORE THAN ONE DATA FILE WITH THE SAME DATA FIELDS IN ALL DATA FILES TO GET THE TOTAL RESULTS IN THE QUERY OF ALL DATA FILE COMBINED. EXAMPLE OF MY CODE. SELECT SHOENAME,SHOESIZE,COUNT(SHOENAME) FROM A1NSSRT.DBF,A2NSSRT.DBF,A3NSSRT.DBF GROUP BY SHOENAME

I tried the above code and it puts the total count of all records in the last record. I am working on the code given above to make it work. Thank you for the starting point. Thank you.

I have a VF6 data file that IS ALREADY SORTED BY GROUPS AND I NEED TO ADD A SEQ NUMBER TO A NUMERIC DATA FIELD STARTING WITH 1 TO END OF THE GROUP FOR EACH GROUPS. THEN SORT WITHIN EACH GROUP. EXAMPLE FRUITS SEQNUMBER APPLES 1 APPLES 2 APPLES 3 APPLES 4...