>>New user says HELP! I am trying to set up a program to compile data and generate a report to count to totals multiple fields (race, sex, employee pay grade & job code), perhaps others as well, but don't know how to go about setting the darn thing up. I want to be able to set up a program to run against a 4000+ person database to do this. Any suggestions?
>
>Normally report data should be collected in a cursor. If you have complicated report algorithm you have to code chain of Select-SQL or even SCAN modules. Be sure that Foxpro is the best data manipulator and if you have the data it could be reported.
Dave: If you're new to SQL, practice with a small PRG that basically does the SQL-Select(s) and displays the results with browse. Check into using phrases like
count(jobcode) as JCTOT
and
group by jobcode
where you have made a new field in the resulting cursor out of the total number of jobcode entries, then grouped them by jobcode. Your result would then show
jobcode jctot
JC 1 5
JC 2 7
JC 3 2
etc.
HTH
Barbara