Searching/Forms/Reports

[Fie]

I currently have 3 tables


1. School ----- list 52 dif schools, no puipils, cost centre number
and mgnt no.
2. Meal Uptake ---- States the day,month & year of the weekending, no
days that week, no meals sold, school name & school code (unique random

no for primary key)
3. Meal Numbers --- no tickets sold, no tickets returned, no free
meals, milk sold, SW MOW, Lunch club no.


What i need to do is make a form that allows users to select a School
(or all schools) and also a month. Each School has data entered each
week in that month. I then need to be able to take the data found from
the search and produce a report which gives totals for the whole month
and the user can print it out...


e.g


Search:


School = Buckie Month = April


Data found:


School Day Month Year No days Tickets Sold Meals
Buckie 06 April 2005 12 4
6
Buckie 5 April 2005 10 5
8
Buckie 24 April 2005 10 6
2


Printable Report:


School Day Month Year No days Tickets Sold Meals
Buckie 06 April 2005 12 4
6
Buckie 5 April 2005 10 5
8
Buckie 24 April 2005 10 6
2


TOTAL 32 15
16


Any1 any ideas as to how to do this HELP