Microsoft Office Access 2007 Forms Reports And Queries Ebookers. Microsoft Office Access 2. Forms, Reports, and Queries: Mc. Fedries, Paul: Trade Paperback: 9. Powell's Books“Everything you need to master Access 2. Charles Carr, Reviews Editor, Computor. Microsoft Office Access 2007 Forms, Reports,. Hyderabad, India. Reviewed 2 October 2015. Good resort,humble staff. I have visited this resort with my family.It was a nice experience.The staff at reception was very good and helped us quite a lot in making arrangements for transport to city etc. Breakfast was good and we had the evening boat cruise also.

Have made an Access 2007 database for tracking food and calorie eaten. I have two tables, one (table 1) has the food information (name, calories per serving, etc. Nod32 Antivirus Free Download Full Version Update. ) The other table (table 2) has what was eaten, number of servings, the meal that it was eaten (breakfast, lunch, dinner, etc), the date, etc. The two table are linked together in a select query, so I can start typing in the food name and it will populate the other fields in table 2. So I then can just input the number of servings, meal, etc.

Problem: I would like to have it like a sub-form data input, where I could just input the date once for the complete day and just input the meal once. A running sum for all calories consumed for the day would be nice. Thanks in advance! I'm not sure what the issue is here.

If I understand your foods table it lists meals and/or specific food items with the calories for that meal or specific food. You then have a log table, that you input what foods you have eaten during the day. This table should look like this: tblFoodLog FoodLogID (PK Autonumber) LogDate FoodID (FK to Foods table) Servings Meal You should have NO fields in the food log that are already in the food table except the food ID. You can create a form in continuous form mode that has an unbound control for the date and just pick up the LogDate from that control. Or default the LogDate to the current date.

Hope this helps, Scott P.S. Please post a response to let us know whether our answer helped or not.

Microsoft Access MVP 2009 Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries Hope this helps, Scott Blog: Microsoft Access MVP since 2007.