Hi Peter, Its a pleasure to (virtually) meet you. That is precisely what I wound up doing after fumbling through my woeful SQL skills <g>... once I figured out that I had to create a column in the table and marry it to the SQL count output I was finally moving forward again. I so desperately want to use PivioTables and Crosstab reports in my apps, but it NEVER works and those two topicsby sdaughtry - WinDev Forum
Table has a 'Country' field defined. Populated with 10,000,000 records with various values (e.g. Belize, France, Spain, USA) I need to build a list of unique Country names and how many records exist for each Country. Sounds simple, but I've chased my tail for 3 days trying to get a Pivot Table or a Crosstab report to do this simple output: Belize 14 France 1,001 Spaiby sdaughtry - WinDev Forum