Results 1 to 2 of 2
  1. #1
    bojamba is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2018
    Posts
    3

    Using Access to Split Lots into Eaches - Searching all over and cannot find.

    To create an On Time Delivery Report, I need to look at multiple dates (Promised Date, Put into Stock Date, Actual Ship Date).

    However, to compare these together, I'm challenged by quantities. We might promise 3 on one day, build 2 and only ship 1.

    In order to manage this, I believe i need to split every date into a Qty of 1 - repeating the same data for the total roll up.

    Is there a function, or workaround that would allow me to repeat each item until it totals the full quantity?

    For example: 4 Widgets for Customer A shipped 1/15 would become:



    1, Widget, A, 1/15
    1, Widget, A, 1/15
    1, Widget, A, 1/15
    1, Widget, A, 1/15

    This lets me compare each individual item against promise, inventory and actual in order.

    I have 100's of these per month, so I can't do it manually. I've searched high and low for an answer and can't seem to find anyone with a similar problem and would greatly appreciate the help.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Here is a link to Database Design and Planning info that may be useful to you.
    You have to start with a clear and complete description of your business.

    There is no magic technique. It's analysis and design of the business requirement(s).

    If you spend 30-60 minutes working through 1 or 2 of the tutorials from RogersAccessLibrary mentioned in the link, you will experience a process applicable to your situation.

    Do not use a naming system that allows embedded spaces in field/object names with Access! It will lead to syntax errors.

    Good luck with your project.

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

Similar Threads

  1. Replies: 3
    Last Post: 09-22-2016, 11:16 AM
  2. Searching on Split-Form to ignore order of text
    By Ekhart in forum Programming
    Replies: 1
    Last Post: 09-07-2016, 02:45 PM
  3. Replies: 8
    Last Post: 09-15-2015, 11:34 AM
  4. Replies: 8
    Last Post: 02-27-2013, 04:56 PM
  5. Replies: 8
    Last Post: 07-13-2012, 04:53 PM

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