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
Query for language
Re: Query for language
Try this:
SELECT Language, COUNT(*)
FROM patient
GROUP BY Language
Modified from another query.
drtmz
SELECT Language, COUNT(*)
FROM patient
GROUP BY Language
Modified from another query.
drtmz
Re: Query for language
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?
SELECT patient.LName,patient.WirelessPhone,patient.language FROM patient
anyway to sort it by language?
Re: Query for language
Try this:
SELECT Language, COUNT(*)
FROM patient
GROUP BY Language
ORDER by Language;
drtmz
SELECT Language, COUNT(*)
FROM patient
GROUP BY Language
ORDER by Language;
drtmz