Results 1 to 2 of 2
  1. #1
    escuro19 is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2009
    Posts
    2

    Find Missing Number in Sequence per Record

    Hello,

    I have a table where each Volunteer start from Day 1 to n...(Sequence)for example:

    Volunteer | Day
    1 | 1
    1 | 2
    1 | 3
    1 | 4
    2 | 1


    2 | 2
    2 | 3
    3 | 1
    3 | 2

    I am hoping if somone could help, i want to be able to loop through a Volunteer' Day, to find missing sequence. eg. the user specify which Volunteer they want to see (using Textbox) then it will bring up just that volunteer and the missing their sequence:

    Volunteer | Day | Error
    1 1 ok
    1 2 ok
    1 4 Error
    1 5 ok

    If possible output it in a datasheet (table).

    Thankyou in advance

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    well you title this 'missing number in sequence' but in your example there isn't any missing number

    I am going to assume you need to do a query on IsNull as criteria for the Day field

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

Similar Threads

  1. Auto Sequence String Serial Number
    By eddyc99 in forum Programming
    Replies: 2
    Last Post: 10-02-2009, 08:11 AM
  2. Find Missing Records
    By Flanders in forum Queries
    Replies: 6
    Last Post: 06-24-2009, 07:02 AM
  3. Replies: 1
    Last Post: 05-16-2009, 08:47 AM
  4. Find Record button error
    By Zedlexx in forum Forms
    Replies: 0
    Last Post: 03-11-2009, 09:26 AM
  5. How to Find a Record
    By lschlitt in forum Programming
    Replies: 2
    Last Post: 09-09-2006, 06:24 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