1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Microsoft Access 2016

Discussion in 'All Other Software' started by sparkyEire, Jun 8, 2017.

Thread Status:
Not open for further replies.
Advertisement
  1. sparkyEire

    sparkyEire Thread Starter

    Joined:
    Jun 8, 2017
    Messages:
    2
    Help!
    Trying to design data base with Access I am trying run a date expiry date.
    Basically I have a number of Memberships or Qualifications that have an expiry of between one and two years and I just need to be able to run a query to show when these will expire

    Thanks in advance


    Tech Support Guy System Info Utility version 1.0.0.4
    OS Version: Microsoft Windows 10 Home, 64 bit
    Processor: AMD A10 Extreme Edition Radeon R8, 4C+8G, AMD64 Family 21 Model 96 Stepping 1
    Processor Count: 4
    RAM: 5708 Mb
    Graphics Card: AMD Radeon (TM) R7 M360, -2048 Mb
    Hard Drives: C: 223 GB (127 GB Free); D: 13 GB (1 GB Free); Z: 0 GB (0 GB Free);
    Motherboard: HP, 80B5
    Antivirus: Windows Defender, Enabled and Updated
    p
     
  2. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    You have a date? or do you have an expire date? What do you want the query to do?
     
  3. sparkyEire

    sparkyEire Thread Starter

    Joined:
    Jun 8, 2017
    Messages:
    2
    I have a start date for each item, so I want to find expire date
     
  4. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    ExpireDate: DateAdd("yyyy",1,[StartDate1])
    If you have an indicator for 1 or 2 years it could look something like this.
    TargetDate: IIF(ContractYears = 1 ,DateAdd("yyyy",1,[StartDate1],DateAdd("yyyy",2,[StartDate1])
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1191156

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice