F
Fie
Hey up...
Need your help on how to do this...
i have 3 tables as mentioned before
1. School
2. Meal Uptake
3. Meal Numbers
in the meal numbers i have a field called SW Meals. I need to design a
form that allows a user to enter in a School name and Month & Year.
When this is done the results are displayed so for
example:
The user enters Alves Primary School, April, 2005
the results should display number SW Meals for the 4 weeks in april.
With these 4 results i then need to calculate a total and multiple it
by £2.38 (thats cost per meal).
Am guessing i need to do some sort of report that calculates the total
and multiplies by £2.38.
But am really unsure as to how this all links together... i have done a
a query that adds new field which breaks down the date that userhas
entered into Month & Year... i know i can add parmaters to the query
that asks user to enter school,month and year and it displays the
results but how do i incorporate this in to fields & reports????
am at a great loss...???
fie
Need your help on how to do this...
i have 3 tables as mentioned before
1. School
2. Meal Uptake
3. Meal Numbers
in the meal numbers i have a field called SW Meals. I need to design a
form that allows a user to enter in a School name and Month & Year.
When this is done the results are displayed so for
example:
The user enters Alves Primary School, April, 2005
the results should display number SW Meals for the 4 weeks in april.
With these 4 results i then need to calculate a total and multiple it
by £2.38 (thats cost per meal).
Am guessing i need to do some sort of report that calculates the total
and multiplies by £2.38.
But am really unsure as to how this all links together... i have done a
a query that adds new field which breaks down the date that userhas
entered into Month & Year... i know i can add parmaters to the query
that asks user to enter school,month and year and it displays the
results but how do i incorporate this in to fields & reports????
am at a great loss...???
fie