help needing to produce a report on user defined fields

[gus904]

I'm running ACT2000, and have added two user defined fields (both simple text status fields).
What is the quickest way to produce a report showing, in effect, a breakdown by status.
If I were running SQL against an enterprise RDBMS (that's the SQL I know) I would code something like:

Select Status, count(*)
From table
Group by status

Is there a way of doing this in ACT2000? or do i need to upgrade in order to be able to run SQL against ACT2000? Or can I do this using some kind of custom report?

Thanks again for your help.
Gus.

 

[GLComputing]

You need to do the Lookup first, then run the report on the results

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au