Results 1 to 4 of 4
  1. #1
    tkendell is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    2

    query to update a date based on another date

    Hi all

    I am relatively new to Access.

    Basically I am trying to create a query whereby when there is a date in one field (e.g. pre_cutoff) then I need to be able to click a button and a date be automatically inserted into another field (e.g. post_cutoff). This date needs to be the first date (from pre_cutoff) plus 98 days.

    Any ideas?

    Tam

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Why do you need to save this date? It could be calculated whenever needed.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    tkendell is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    2
    Because the value in this field (post_cutoff) is then used as a criteria to create reports.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I initially read this as you were wanting to save to field of table. Is that what you want? If so I still advise that this is not necessary. You can produce this value when need by calculation in a query or form/report textbox. In a query simply create a field with an expression on the Field row of the designer. If you want to save the value to a table will need to run an Access UPDATE query or execute code in some event behind a form.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. date selection update query
    By mountainwombat in forum Queries
    Replies: 2
    Last Post: 06-07-2011, 09:29 PM
  2. Replies: 7
    Last Post: 05-31-2011, 11:51 AM
  3. Run Query based on date for Multiple days
    By jedwards85 in forum Access
    Replies: 3
    Last Post: 03-29-2011, 12:04 PM
  4. Replies: 1
    Last Post: 02-06-2011, 06:36 PM
  5. Query Based On Date Ordered
    By dr_destructo in forum Queries
    Replies: 2
    Last Post: 07-15-2010, 03:34 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