Results 1 to 3 of 3
  1. #1
    FranCorona is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    May 2013
    Location
    California
    Posts
    74

    Parameter coming up for expiry date


    Good Morning. I have a query that brings up employee's license expiration dates.

    I have following fields:
    EmpName AACDate AACExpDate: DateAdd("yyyy",4,[EmpAACDate]) EmpStateLicExpDate NGLicExpDate: IIf([EmpStateLicExpDate]<[EmpAACExpDate],[EmpStateLicExpDate],[EmpAACExpDate])

    The first query I did for just bringing up the expiration dates works fine, but when I created another query to bring up the actual license it asks for a parameter for the AACExpDate. I can't figure out why this is coming up.....when I click ok it runs the query with the correct info as far as I can see, but I would like to get rid of the parameter box. I tried with: EmpAACExpDate: [EmpAACDate]+1460 and that also brings up the parameter box. I have been searching through help topics both online as well as in Microsoft Help but can't figure it out. Thank you for any and all help with this.

  2. #2
    FranCorona is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    May 2013
    Location
    California
    Posts
    74
    I solved it. I just recreated the query from scratch and now it is working....don't know what was happening but oh well. LOL Everyone have a wonderful weekend!

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Thanks for sharing your success and solution with us.

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

Similar Threads

  1. expiry date query help
    By graemespence1 in forum Queries
    Replies: 3
    Last Post: 11-22-2011, 09:23 PM
  2. Multiple Qualificaions with expiry
    By cottoman in forum Access
    Replies: 4
    Last Post: 10-25-2011, 06:15 AM
  3. Calculating Expiry Date -
    By Jojojo in forum Programming
    Replies: 12
    Last Post: 10-05-2011, 12:05 PM
  4. Parameter Date - Force a Monday Date
    By ker9 in forum Queries
    Replies: 3
    Last Post: 07-26-2011, 01:06 PM
  5. Replies: 2
    Last Post: 04-27-2010, 01:25 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