coverting an Excel "IF" Statement to Access

[Longbeach]

i have the following if statement in an excel spreadsheet
my boss now want the whole data sheet transfered to Access can anyone please
help with the covertions of this IF statement to work in Access

=IF(Expiry Date<>"",IF(Expiry Date <Todays Date,"Cease Working ",IF(todays
date> Expiry Date -60,"Submit New Application"," ")),"")

Where Expiry Date and Todays Dates are Cells in Excel
Thank you for your assistance
Lina

 

[Al Campagna]

See my response to your 12/5/07 - 8:16 post. Please try to be patient for a
response, and avoid reposting the same question too soon.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Longbeach]

All i got from your response was a link to a web site for a company this will
not help me with my current request.
thanks all the same
Lina