Results 1 to 6 of 6
  1. #1
    MFS is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Mar 2009
    Location
    Ohio
    Posts
    235

    Adding numbers to dates

    Date Completed. = Date last Completed.


    Reoccurrence. = 3 (Meaning every 3 days.)
    Next Due Date = Date last completed + the Reoccurrence value

    How do I show the Next Due Date? [Reoccurrence]+[Date Completed] ?? Does not work.

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    [Reoccurrence]+[Date Completed] should work if reoccurrence is a NUMBER and [date completed] is a DATE.

  3. #3
    MFS is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Mar 2009
    Location
    Ohio
    Posts
    235
    Yes they are,
    I put this expression in a query under the Next Due Date field in criteria.
    But am having no success.

  4. #4
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    what did you get while you said you have no success?

  5. #5
    MFS is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Mar 2009
    Location
    Ohio
    Posts
    235
    Got it, Needed to put the expression beside the field name not in criteria.

  6. #6
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295

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

Similar Threads

  1. Mixed dates - show only complete dates?
    By weeblesue in forum Queries
    Replies: 3
    Last Post: 10-27-2010, 02:15 PM
  2. numbers
    By Balen in forum Access
    Replies: 1
    Last Post: 08-17-2010, 05:16 PM
  3. Record Numbers
    By nashr1928 in forum Forms
    Replies: 7
    Last Post: 06-26-2010, 07:58 PM
  4. Record numbers
    By nashr1928 in forum Reports
    Replies: 2
    Last Post: 06-25-2010, 03:58 PM
  5. Rounded Numbers
    By TundraMonkey in forum Access
    Replies: 3
    Last Post: 08-11-2009, 12:19 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