Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: wilsong21
  • Content: Threads
  • Order by date
  1. wilsong21

    CODE 10% OF A DATA FILE BASED ON TEST SCORE

    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...
  2. wilsong21

    PERFORM A QUERY ON MORE THAN ON DATA FILE

    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
  3. wilsong21

    How do I append a record number within new groups

    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...

Part and Inventory Search

Back
Top