here is your report.
i added another table, MealNameLocation.
the purpose of the above table is to
correctly sort/position the MealName and MealLocation
in order.
created two queries, qryXTAB_Orig, qryXTAB.
they are same. the report uses qryXTAB.
on the open event of the report,
we use the original query string from
qryXTAB_Orig and add a 'Where Clause' to
filter the result.
the resulting SQL (with filter) is then put to qryXTAB.
on the Open Event of the Report, i set the Control Source
of each textbox to the correct field in qryXTAB. therefore
making it dynamic.
its too complicated, so if you have questions, reserved
it and try to study the code first.
use the Form to enter the StartDate of the report.