#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Nov 2016
    Posts
    1
    Rep Power
    0

    Access query help


    I am creating an Access Database and would like a query to calculate service in years and days from a "date of enrollment" [DOE] field. can anyone help me with this. Thanks.
  2. #2
  3. Moderator
    ASP Super Genius (4500 - 4999 posts)

    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,626
    Rep Power
    653
    Calculating elapsed time is a common requirement. Probably need a custom function. Google for it. When you develop code that has issue, post it for analysis.
    I like to know if my suggestion helped you. One way to let me know is by clicking star at bottom left corner of post.
    Debug!Debug!Debug!http://www.cpearson.com/excel/debug.htm

Similar Threads

  1. ASP Query Access Query Different results
    By jj72uk in forum ASP Development
    Replies: 4
    Last Post: May 25th, 2011, 11:37 AM
  2. Access Query: Can you Query by a Date Range?
    By the_master68 in forum Microsoft Access Help
    Replies: 2
    Last Post: April 8th, 2011, 12:43 PM
  3. Converting Access to Access Project Query problem
    By mjliscio in forum Microsoft Access Help
    Replies: 2
    Last Post: September 20th, 2007, 02:28 PM
  4. Replies: 7
    Last Post: January 12th, 2007, 05:17 PM
  5. Query Access with multiple Query??
    By DBob in forum ASP Development
    Replies: 8
    Last Post: April 28th, 2006, 05:41 AM

IMN logo majestic logo threadwatch logo seochat tools logo