Expiration Date

[nhoover]

My first post...I hope this works!



So what I have is a small works roster. The roster has one entry for date of acceptance, when I received the application. This date has a two year life span, when that two years is up its either renewed or thrown out. What I need is a way for a "tickler" to show up and tell me when that date is expired. Either by color or a yes no function...i'm new to access so bare with me. Please give me some feedback, a little help, or just some basic knowledge on what to do. I've looked this up but for the life of me I can't figure out what to do.

This is the only function i've entered but i must be doing something wrong. =IIF([txtexpireddate]<Date(),"yes","no")

I'm lost...

[June7]

You entered that expression in a textbox ControlSource? Why doesn't it work - error message, wrong results, nothing happens?

[nhoover]

The expression is entered into data type date/time...not a text box. And yes, an error message shows. Thanks for the quick response.

[June7]

I don't understand what you are trying to do. How can that expression be in date/time datatype field? Attach some images of what you have done or provide the db. Follow instructions at bottom of my post.

What is the error message?

[nhoover]

Small Works Roster Database.zip

This work?

So under the Date issued column, I would like to have something that helps notify me when they're two years old. Like I said i'm new to access for the most part so learning to do these would be great. Thanks for the help.

[June7]

Can't find anything named txtexpireddate nor anything with that expression.

If you want report filtered to show only expired records, then need to base report on a query instead of just table as RecordSource.

SELECT * FROM [Small Works Roster] WHERE DateAdd("yyyy",2,[Date Issued])<Date());



You have several label controls with error on the Caption property because of ampersand. A single ampersand defines a shortcut on the character that follows it. If you want an actual ampersand to display then must repeat the ampersand:

Railroad Construction && Marina
Curb && Gutter/Sidewalks
Water Lines 12" && Smaller
Water Lines 12" && Larger

Advise no spaces, special characters/punctuation (underscore is exception) in any names.