Results 1 to 3 of 3

Update ID with FY based on Requested Date

  1. #1
    Join Date
    Jul 2019
    Posts
    16

    Update ID with FY based on Requested Date

    I have two issues and not sure they can be solved together:



    1. I have a field ID_PK that I will start to use as the actual Tracking ID of items (currently have another field that contains TrackingID), is there a way to auto populate the OldTrackingID field the ID_PK, without overwriting current TrackinID?

    2. When TrackingID is update add the FY## to the beginning, which would be based off date of RequestDate field?

    Your guidance is much appreciated!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,698
    1.txtOldTrackingID = txtID_PK

    2. txtTrackingID = "FY" & FORMAT(txtRequestedDate, "yy")

    (or format it to your specs)

  3. #3
    Join Date
    Jul 2019
    Posts
    16
    Is this an update in Design View Format?

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

Similar Threads

  1. Update table based on Max date link
    By janmack79 in forum Queries
    Replies: 2
    Last Post: 04-11-2017, 12:46 PM
  2. Update Field based on Max Date
    By janmack79 in forum Queries
    Replies: 27
    Last Post: 01-18-2017, 01:07 PM
  3. Update Query based on existing date
    By axdxnco in forum Queries
    Replies: 1
    Last Post: 06-12-2013, 02:15 PM
  4. Replies: 3
    Last Post: 01-24-2013, 02:08 PM
  5. query to update a date based on another date
    By tkendell in forum Access
    Replies: 3
    Last Post: 06-29-2011, 09: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
  •  
Tech Forums: Microsoft Office Forums