need sql statement

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?

Thanks for the reply, I have viewed the tutorials but in my case I just don't know how to form the sql statement with the data I have, this is what I need help with.

cuedog wrote: 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.

Well if you don't need the breakdown by date (ie the numbers from the last 30 days), it's not that hard.  I'll show you how to do it without the date, and if you need the date, it should not be to hard to add...

SELECT count(patient_id), diet
FROM patient_status
GROUP BY diet;

Basically just get the count of patient_id's, and group by their diets.  That will give you all of the patients for that diet, but there is no date restriction, it will go all the way back to the beginning of your data.

http://www.w3schools.com/sql