Not sure what to do

[Fie]

Currently iv got 3 tables

School Details
Meal Uptake
Meal Numbers


reports need to be engerated on data in the tables, but i need to
design some sort of form that allows user to either pick a School or
enter Date range (e.g 1st April to 31st April... 1st etc etc) and then
can print off report with all the figuers on it...!! I have designed a
query that does the calcualtions that need to be done i.e the % uptake
of meals is calculated, possible number of meals and these figues need
to present in the reports.

ANY IDEAS as to best way to do this..???

 

[betwalk]

Create a blank form with text box controls for the user to enter a
beginning and an ending date. Let's say you call those txtGetStartDate
and txtGetEndDate. Let's also say that you call the form where the
user enters these values frmReportMenu. In the query that underlies
your report, you'll want to filter by whatever dates the user enters.
The criteria will look like this:

[Forms]![frmReportMenu]![txtGetStartDate]
and
[Forms]![frmReportMenu]![txtGetendDate]

Now you can use the button wizard on this report form that will open
the report you have designed that is based on this query.

hth- Betsy