In Access I can run a cross tab query that will show me for example: how may records belong to specific customers store. It uses the count and group functions. So I get results as such:

Store CountofStore
South 250
North 85
East 120

I need the same type of query in FoxPro that will give me a table that I can export as a dbf. I can not use printed report that Foxpro uses in it's Query Wizard for cross tab.

Is there a simple function statement that will give me what I need?

Thanks