How do i find out the number of diffent entries in a specific field? and select one each type for printing.
table:
Fields=Name, Country, Age
Tony, England, 40
George, USA, 37
Saddam, Iraq, 65
Colin, USA, 46,
Jack, England, 47
what I then want to displayed is:
There are '5' people living in '3' different countries. England, USA and Iraq.
So, how can I find out that there are '3' diffent entries in the country field and display each of them?
Any help would be great, thanks!
