Results 1 to 2 of 2
  1. #1
    eliedebs is offline Novice
    Windows 2K Access 2007
    Join Date
    Jan 2012
    Posts
    2

    Post Loop through recordset

    Hi Guys. I have a table that stores staff and their daily sickness record (fields: EmployID, SickDate). I want to create a code (using loop thorugh recordset) to generate a new table(fields: EmployID, SickFrom, SickTill) that stores the range of sick leave of each employee. So for example if the first tablethe first record reads: Employee A is sick on 1.1.2012, record 2 reads employee A sick on 2.1.2012, record 3 reads employee A sick on 5.1.2012, record 4 reads employee B sick on 2.1.2012 and record 5 reads employee B sick on 3.1.2012. I want the code to store the following in table 2: Employee A sick from 1.1.2012 till 2.1.2012, a new record reads employee A sick from 5.1.2012 till 5.1.2012 and a new record reads employee b sick from 2.1.2012 till 3.1.2012.

  2. #2
    eliedebs is offline Novice
    Windows 2K Access 2007
    Join Date
    Jan 2012
    Posts
    2
    fdddddddddddddddddddd

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

Similar Threads

  1. Help with a For Loop in VB
    By JFo in forum Programming
    Replies: 5
    Last Post: 09-29-2011, 02:45 AM
  2. Do While loop
    By jgelpi16 in forum Programming
    Replies: 7
    Last Post: 07-23-2010, 08:21 AM
  3. Bulk Email / Loop through recordset
    By smikkelsen in forum Forms
    Replies: 4
    Last Post: 07-12-2010, 06:59 PM
  4. VBA Loop
    By DreamOn in forum Programming
    Replies: 4
    Last Post: 06-25-2010, 03:35 AM
  5. Replies: 1
    Last Post: 11-13-2009, 03:03 AM

Tags for this Thread

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 - Senior Forums