Results 1 to 2 of 2
  1. #1
    armyofdux is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2014
    Posts
    55

    Default Value and Expression Minus 1 Day

    So I am trying to setup a default value in the tbl design. The Following two fields are the two in question(StartDate & ReportDate). It already has relevant dates properly formatted in the StartDate Field. The ReportDate will always be the day before or minus 1 day from the Startdate. My question is that I can't seem to get the syntax right to make it work. Screenshot included. Click image for larger version. 

Name:	Screen.jpg 
Views:	4 
Size:	95.5 KB 
ID:	19922

  2. #2
    armyofdux is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2014
    Posts
    55
    So I have found it is just much easier to save an update query with DateAdd("d",-1,[StartDate])

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

Similar Threads

  1. Expression for Default Value
    By SmartestIdiot in forum Forms
    Replies: 7
    Last Post: 01-26-2014, 02:48 AM
  2. Sum IF else minus
    By AussieGal in forum Access
    Replies: 2
    Last Post: 03-07-2013, 07:15 PM
  3. Plus minus drop down menu
    By ashu.doc in forum Forms
    Replies: 3
    Last Post: 08-09-2012, 10:04 PM
  4. Workaround for MINUS (with Where)
    By Autoclave in forum Queries
    Replies: 2
    Last Post: 10-31-2011, 08:15 AM
  5. minus particular Items (barcode) only...
    By alex_raju in forum Access
    Replies: 1
    Last Post: 06-28-2011, 11:11 AM

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