Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group by field state
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01367170
Message ID:
01367172
Views:
6
>My table survey.dbf have fields: course and state
>
>I need to see the result of the survey
>
>I start by using the course name and state as below:
>
> count for course = "refrigeration" and state = "SP"
> count for course = "refrigeration" and state = "PR"
>
>But as I have many states, and not sure if all states exist, I would like to have a command that group all states,
>so I do not need to worry about states
>
>T.I.A
>
>Moises

I am not sure what you want.
Could you post some example data and what you want from it?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform