Search results

Good point MajP. Summary information is all that is needed.

Thank you MajP! I like your form design. I think someone not very familiar with computers would be able to fill this out very easily. Thanks again!

Thank you jdraw. Here are the tables I will be using for this process. I need to create a table to hold the meals.

Thank you jdraw! This information is currently not recorded now. I need to set up a form for it. The information will be part of a display (Access report) that shows how many meals/day for the kitchen staff. As well as how many meals/dining room/meal type, it displays any "special meals"...

Thank you Gasman! This would require the person inputting the information to go through this form at least 60 times daily (given 20 individuals and 3 meals/day). I'm trying to come up with an idea where perhaps all the individuals "assigned" to this facility (there is only one facility I'm...

Thank you Ranman256. What about the form to input this data? I've got maybe 20-30 individuals assigned to this facility and about 150 individuals total. I need to make it as simple as possible as the person who will input the data daily is not highly experienced with computers.

I'm asking for suggestions on how to do the following: I need to design a form(s) to input who will attend meals (B/L/D) each day. This is for a group of individuals, some of whom are assigned to a facility. Most of the individuals assigned to the facility attend all meals, but it is possible...

Thank you to all! This gives me a lot to look at.

Thank you CJ. As I understand the plan, it is to purchase MS Office 365 Business. This solves their problem of maintaining a network server and works well, I understand, for Outlook but Access is a problem. Currently there are two users of the database but more (probably not more than 10)...

I help a company currently using Access to manage day-to-day activities of their site. They have historically maintained a network server and the database (back end) lives here. They are considering "going to the cloud" so as not to have to maintain this network server. Not completely sure...

arnelgp, I need the report to show Sunday through Saturday of the week of the date selected on "select date" form. Where can I change that code?

Thank you so much arnelgp and JHB! I have downloaded your reports and am studying them. You are such elegant programmers!

Thank you all so much! I think at this point I would like to use Access if possible to group/sort the report into the format needed. Introducing Excel into this is going to take more time than I have. If anyone could help me group/sort the data I would very much appreciate the help. I cannot...

Thank you plog. The data in the report is a summary and only lets the staff know there are, for example, 2 "special meals." They somehow have to be able to find out what these meals are: diabetic, gluten-free, dairy-free....etc. If the report is done in Access I think I can create an on-click...

Thank you so much Plog. My concern with using Excel is, as I mentioned above, I need to "drill down" or something so that they can see what constitutes a particular "special meal." I can do that with Access but not sure that's possible with Excel.

Thank you! Attached is database with some data. The report format I need is in post #9. Thank you so much - I truly appreciate all your help.

Thank you all! I have redesigned my table as follows: MealID MealDate MealName MealType MealLocation MealCount How do I get into the format I need on the report? I know its through grouping but not quite sure how/what to group. Thank you all so much!

Thank you ridders. I'll try to get the vb updated as soon as I can to normalize the table and get back.

Thank you Plog. I can follow your suggestions and try to create an Excel file from a query of the temporary table. That being said, this report is to run in the kitchen where meals are prepared. They will need to somehow see what "special meal" is needed (in the SM column in my example)...

Thank you Plog. The data is in a temporary table created each time the report is run. I'll have to go back and rewrite the vb that inserts the data into the table and get it into the format you suggest. In the meantime, how would I do a "pivot table" is Excel? Can I run this Excel report...