need sql statement

[s4dadmin]

I have a table called patient which holds patient information like their name and address. I have another called [patient status] which holds diagnosis, patient id, and diet. And another called admission which holds the patient id, and date_admit. I am using MS Access 2000. I need to make 2 reports.

1. Breakdown by numbers of patients classified by type of diets.

2. Display a list of all patients that were treated for the same diagnosid during the past 30 days.

Can anyone help?

 

[Jonax]

1.
SELECT COUNT(patientid) FROM [patient status] GROUP BY diet ORDER BY COUNT(patientid) DESC

2.
--replace the 7 to select diagnosid
SELECT patientid, name FROM patient p INNER JOIN [patient status] ps ON p.patientid = ps.patientid INNER JOIN admission a ON p.patientid = a.patientid WHERE date_admit > now()-30 AND diagnosid = 7

 

[s4dadmin]

Thanks Jonax, the number 2 sql statement is perfect, but I still need help with number 1. I need to show the name of the diet, your sql statement does not show that.

 

[s4dadmin]

Never mind I got it