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

    Join Date
    Nov 2016
    Rep Power

    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
    The Great Land
    Rep Power
    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.

Similar Threads

  1. ASP Query Access Query Different results
    By jj72uk in forum ASP Development
    Replies: 4
    Last Post: May 25th, 2011, 10: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, 11:43 AM
  3. Converting Access to Access Project Query problem
    By mjliscio in forum Microsoft Access Help
    Replies: 2
    Last Post: September 20th, 2007, 01:28 PM
  4. Replies: 7
    Last Post: January 12th, 2007, 04:17 PM
  5. Query Access with multiple Query??
    By DBob in forum ASP Development
    Replies: 8
    Last Post: April 28th, 2006, 04:41 AM

IMN logo majestic logo threadwatch logo seochat tools logo