Hi
You can use crosstab query.
If you use Query Wizard you will need to add a dummy field in your table, because the wizard need 3 fields to make a crosstab query. Put Map in Row, Issue in Column and DummyField in Data. In step 3, select count in Summary, maybe you can use None in Subtotals...
Hi,
there are several way to count record :
1. you can count record using COUNT FOR (your filter expression) if your view/table not filtered.
2. If your view already filtered (in local or remote view or filtered in cursor / Alias properties) you can use RECCOUNT(cAliasName) function.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.