Results 1 to 3 of 3
  1. #1
    Top Tuna is offline Novice
    Windows 8 Access 2016
    Join Date
    Apr 2020
    Posts
    12

    Showing an incremented date on a form

    I have a database that I wish to display on the home screen (switchboard) a forthcoming date for the next purchase of items . This date doesn't relate to any items in the database except that I want it to roll over from a start date every 28 days merely as a reminder to the user that this date is the next purchase date.
    I would appreciate any help I can get on this.


    cheers,
    Top Tuna

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    in a query : DateAdd("d",28,[StartDate])

  3. #3
    Top Tuna is offline Novice
    Windows 8 Access 2016
    Join Date
    Apr 2020
    Posts
    12
    Thanks Ranman.

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

Similar Threads

  1. Replies: 29
    Last Post: 03-07-2019, 03:29 PM
  2. Replies: 10
    Last Post: 09-13-2018, 07:16 PM
  3. Display incremented value in form
    By scottdg in forum Programming
    Replies: 23
    Last Post: 05-18-2015, 09:35 AM
  4. Replies: 4
    Last Post: 01-04-2015, 02:38 PM
  5. Future Date that may be incremented
    By h1mself2 in forum Access
    Replies: 3
    Last Post: 12-14-2012, 04:11 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