Results 1 to 3 of 3
  1. #1
    chucku is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    2

    Multiple Min/Max dates by sequential dates

    I have a scenario where the first three rows of date which have dates of 4/1, 4/4/ 4/6 with ndc 5513026701; next six rows that have dates from 4/8 to 4/20 with ndc 5513014801; next three rows that have dates from 4/25, 4/27, 4/29 with ndc 5513026701.



    The issue I am having is I do not know how to have separate min/max dates for ndc 5513026701 since when I group by ndc 5513026701 min = 4/1 ; max = 4/29. I need to have min = 4/1 and max = 4/6 for one row and another row of min = 4/25 and max = 4/29.

    Can anyone have easy way to sequentially create min/max for each ndc 5513026701? I wasn't sure how to verbalize this so I have attached a sample worksheet. Thank you
    Attached Files Attached Files

  2. #2
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    Quote Originally Posted by chucku View Post
    I have a scenario where the first three rows of date which have dates of 4/1, 4/4/ 4/6 with ndc 5513026701; next six rows that have dates from 4/8 to 4/20 with ndc 5513014801; next three rows that have dates from 4/25, 4/27, 4/29 with ndc 5513026701.
    How do we know / tell access, that, 4/1, 4/4/ 4/6 with ndc 5513026701 belong to one group & next three rows that have dates from 4/25, 4/27, 4/29 with ndc 5513026701 belong to another group or is that the problem?

    Thanks

  3. #3
    chucku is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    2
    That is the problem. After 4/6, another NDC number is present and then back to the original NDC (5513026701). I need to somehow insert a function which give a unique id for the dates 4/1 - 4/6 (i.e. flag = 1).

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

Similar Threads

  1. Query input dates for range of dates in two fields
    By kagoodwin13 in forum Queries
    Replies: 3
    Last Post: 02-13-2012, 04:25 PM
  2. Replies: 10
    Last Post: 11-16-2011, 10:58 AM
  3. Query Criteria with Multiple Dates
    By Jojojo in forum Queries
    Replies: 3
    Last Post: 10-08-2011, 05:07 PM
  4. multiple records with consecutive dates
    By sotssax in forum Forms
    Replies: 2
    Last Post: 07-26-2011, 04:23 AM
  5. Mixed dates - show only complete dates?
    By weeblesue in forum Queries
    Replies: 3
    Last Post: 10-27-2010, 02:15 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