Microsoft Access Calculated Field - Expiry Date

Access Discussion in 'Microsoft Office' started by GeorgeHat, Mar 22, 2015.

  1. GeorgeHat

    GeorgeHat

    Joined:
    Mar 22, 2015
    Likes Received:
    0
    Hi guys, I'm very new to access and I'm having some issues. I have made a field for an expiry date, and I have attempted to create a calculated yes/no field that gets ticked when the expiry date is up, so basically I have a box that I want ticked for when the expiry date is before the current date (I hope that makes sense). Thanks guys,

    George
     
    GeorgeHat, Mar 22, 2015
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. MatthewAbbott

    Access Microsoft Access frontend on a SQL Server Database

    MatthewAbbott, Jun 17, 2005, in forum: Microsoft Office
    Replies:
    0
    Views:
    806
    MatthewAbbott
    Jun 17, 2005
  2. aaldridge
    Replies:
    3
    Views:
    1,114
    cvo-aalst
    Jun 20, 2005
  3. AJCButler

    Access Microsoft Access Page Setup Problems

    AJCButler, Oct 12, 2005, in forum: Microsoft Office
    Replies:
    0
    Views:
    450
    AJCButler
    Oct 12, 2005
  4. mark12345

    Access Microsoft Access Trouble

    mark12345, Mar 27, 2007, in forum: Microsoft Office
    Replies:
    0
    Views:
    429
    mark12345
    Mar 27, 2007
  5. Joemully

    Access ACCESS 2007 Calculated Primary Field

    Joemully, Dec 19, 2010, in forum: Microsoft Office
    Replies:
    0
    Views:
    767
    Joemully
    Dec 19, 2010
  6. Jerry Tack

    Access MS Access Concatenate a date and text field

    Jerry Tack, Jun 3, 2011, in forum: Microsoft Office
    Replies:
    16
    Views:
    8,166
    Jerry Tack
    Jun 18, 2011
  7. maryanny143

    Excel Excel Help: IF date=date, sum

    maryanny143, Nov 8, 2011, in forum: Microsoft Office
    Replies:
    0
    Views:
    898
    maryanny143
    Nov 8, 2011
  8. Corinneo

    Excel Excel get a calculated value to land on a specific date

    Corinneo, Feb 21, 2014, in forum: Microsoft Office
    Replies:
    0
    Views:
    957
    Corinneo
    Feb 21, 2014
Loading...