Results 1 to 2 of 2
  1. #1
    EU1010 is offline Novice
    Windows 10 Office 365
    Join Date
    Dec 2020
    Posts
    1

    Exclamation Inputting data for multiple weeks and retrieving the data based on the week you select.

    I have a little more than basic knowledge of Access. I'm currently helping a meals on wheels program that maintains an Access database for client demographics, create weekly delivery routes, and populate reports of the number of meals needed for the week. The one thing I'm struggling with is how to input data based on a specific day or week. For example, client A receives 3 meals on Tuesdays and 4 meals on Friday every week. However, for next week ONLY (week of the 28th) the client wants to change his delivery to 3 meals Wednesday and 4 on Friday. Then his delivery schedule will default back to 3 on Tuesday 4 on Friday. Right now I'm literally creating a whole new database for each week (by copying from the previous week). I want to do it in one database only. I have no idea how to structure that relationship.

    Tables



    ClientContact
    ClientMealInfo
    ClientDeliveryInfo
    ClientStatus
    Routes

    Reports

    There's one report for each route that shows the delivery schedule (ClientDeliveryInfo) for each week for all Active clients (ClientStatus) and it includes: the client's information (ClientContact), and # of meals per day (ClientDeliveryInfo).

    Desperately looking for some guidance! Thank you!

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    The way I handeled this (for working hours) was to have a table for the defaults, then when appended amend for the actual for that week.?

    So in your case you cuould have a table with the these details, those records gets appended, then change the Tuesday to Wednesday before you generate the delivery orders?

    HTH
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-01-2018, 01:36 PM
  2. Replies: 1
    Last Post: 10-01-2016, 04:10 PM
  3. Replies: 26
    Last Post: 11-05-2015, 01:58 PM
  4. Combine Multiple Weeks of Data
    By Rustin788 in forum Queries
    Replies: 1
    Last Post: 09-24-2014, 08:40 AM
  5. Replies: 3
    Last Post: 11-22-2011, 11:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums