Query used to generate weekly menu report not displaying name nut unique identifier

[nika.duncan]

Good morning,



I have a problem with a lunch menu sytem I am trying to create. The query that I have created to display the menu for Monday called "Monday" is not displaying the Protein name the day of the week name either. It seems to be using the unique identifier, even though I think I selected the field to be displayed. Please have a look at the query and the report generated "Monday" and see how you can assist please.

Please see database attached for any help.

Nika

[ranman256]

if you look at the macro in MONDAY button,
it wants to open the report MONDAYS ORDER.
there IS NO report called mondays order, there IS a report called MONDAY.

you can only select items in the box, so change REPORT NAME: to MONDAY.

[davegri]

You need to add Menu_Choices table to the query. Then all the food columns need to be pulled from that table, not Staff_Detail. Running that query will show nothing because Staff_Detail.MenuID is blank in all the records. Enter a number here corresponding with a menu, and the query will show as desired.
You will need to populate the MenuID field in Staff_Detail, somehow, but maybe that's another thread to come...

As for the report, if you do the above, the food comboboxes can be changed to textboxes (right click, change to) and their data sources changed to carb_det, Veg_det, etc.
You may have to adjust the sort/group to correspond with the new field names.

Edit: Ranman is correct. The macro calls for a non-existent report. I ran the query and report directly from the Navigation Pane, not the form so I didn't run into the invalid report name. In any case, you still need the changes to the query and report for the report to run properly.