Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Forms - Returning text based on mulitple criteria 1

Status
Not open for further replies.

Powerhouse123

IS-IT--Management
Joined
Nov 22, 2007
Messages
41
Location
GB
Hello,

I have a form whereby I want to return a value in the "Valid" field (see below) of "Yes or "Overdue" based on a calculated field and against today's date.

e.g.

Issue Date: 01/01/2005

Expiry Date: (code in control source =DateSerial(Year([Issue Date])+3,Month([Issue Date]),Day([Issue Date]))

field value = 01/01/2008

Valid: I have tried the folowing formula in the control source ...=IF([Expiry Date]=Date(),"Yes","Over Due") This idea works in Excel but I cannot work it out in Access.

So summary of problem in Valid field control source...I want it to say "Overdue" if the expiry date is equal to or greater than today's date.

Many thanks in advance.

Kindest Regards,
 
Access has seven forums. This should be posted in Microsoft Access Forms forum.

It's IIF.

"the expiry date is equal to or greater than today's date."
=>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top