Results 1 to 2 of 2
  1. #1
    ANDRE726 is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Jan 2010
    Posts
    1

    How to update access table

    I have 4 columns of interest in my table
    userid...number
    groupcode...text(10)
    startdate...datetime
    enddate....datetime

    records are organized by userid by groupcode
    example

    125 AH0055A 1/22/2010 08:00 AM 1/22/2010 08:15 AM
    125 AH0055A 1/22/2010 08:00 AM 1/22/2010 08:17 AM
    125 AH0055A 1/22/2010 08:00 AM 1/22/2010 08:19 AM
    125 AH0055A 1/22/2010 08:00 AM 1/22/2010 08:22 AM


    125 AH0055A 1/22/2010 08:00 AM 1/22/2010 08:25 AM
    125 AH0055A 1/22/2010 08:00 AM 1/22/2010 08:29 AM

    Each group has the same startdate throughout with different enddate. What I am trying to do is to change the next startdate/time to the previous record enddate/time. Results would look as follows

    125 AH0055A 1/22/2010 08:00 AM 1/22/2010 08:15 AM
    125 AH0055A 1/22/2010 08:15 AM 1/22/2010 08:17 AM
    125 AH0055A 1/22/2010 08:17 AM 1/22/2010 08:19 AM
    125 AH0055A 1/22/2010 08:19 AM 1/22/2010 08:22 AM
    125 AH0055A 1/22/2010 08:22 AM 1/22/2010 08:25 AM
    125 AH0055A 1/22/2010 08:25 AM 1/22/2010 08:29 AM

    I can do this manually for 10 or 20 records but I have 25,000 records to update. Can anyone enlighten me as to how this can be done. Any help would be greatly appreciated.

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    The End Date is Redundant Data.

    If there is a new Start Date then the previous should be ignored.

    The End Date is in actual fact the next Start Date.

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

Similar Threads

  1. Replies: 3
    Last Post: 01-21-2010, 08:10 PM
  2. Replies: 5
    Last Post: 01-05-2010, 10:22 PM
  3. Update table
    By metro17 in forum Forms
    Replies: 0
    Last Post: 09-23-2009, 04:42 PM
  4. Replies: 4
    Last Post: 09-03-2009, 02:01 PM
  5. how to update only one field in 1 table?
    By viccop in forum Access
    Replies: 3
    Last Post: 02-21-2009, 02:32 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