Results 1 to 2 of 2
  1. #1
    IsaacRCCL is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2019
    Posts
    10

    New to Access, Need HELP with formatting

    I have a access database that retrieves a customers date of application (LE) and amount of time he's eligible for our services (LF.)

    I need to add the number of months (LF) to the date of application (LE) and get the new date. I also need it to display the last day of that month.

    Here's an example

    if LE gives me: 02/01/2019


    and LF gives me: 06

    I need to query to display: 08/01/2019
    also to display: 08/31/2019 in another field.

    Please help.. Thank you for a project

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Let's start with the DateAdd() function using your fields for the second and third arguments.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 2
    Last Post: 11-12-2015, 10:46 AM
  2. Conditional Formatting in Access
    By Triland in forum Access
    Replies: 29
    Last Post: 01-18-2013, 01:00 PM
  3. Access Conditional formatting
    By mailboy in forum Access
    Replies: 1
    Last Post: 12-17-2011, 01:34 AM
  4. formatting in Access
    By yiyi in forum Access
    Replies: 8
    Last Post: 11-19-2010, 03:54 PM
  5. font formatting Access 03
    By Sarge, USMC in forum Access
    Replies: 1
    Last Post: 10-05-2010, 09:40 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