My boss told me this list is the heat! So here I am needing help. I am running a query to get distinct countries from a table. Nezt I would like to count how many entries in the table for each country and then display count like this:
Brazil 5 USA 90 and so on. I have tried two different scenarios and keep getting stuck on the second count query. Any suggestion?? Oh great list members. Thanks, ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
