Query for language

[valoo]

I need to have a query for the languages used by patients eg. a list of patients that speak english, another list for patients that speak chinese. Does anyone know what is the query for it?
Tried SELECT patient.LName FROM patient WHERE patient.language = 'English'
Didn't seem to work. Can any one tell me where I went wrong?

Thanks

[drtmz]

Try this:

SELECT Language, COUNT(*)
FROM patient
GROUP BY Language

Modified from another query.

drtmz

[valoo]

Thanks... modified it again to show me the whole list
SELECT patient.LName,patient.WirelessPhone,patient.language FROM patient

anyway to sort it by language?

[drtmz]

Try this:

SELECT Language, COUNT(*)
FROM patient
GROUP BY Language
ORDER by Language;

drtmz