Expert: Scottgem - 2/5/2005

Question
Hi Scottgem,

(Using Access 2003 at work, 2000 at home)

Hope you can help.
I have a table with a couple of date fields. One giving the start of an activity and one giving when the activity will end.
Is it possible to have another field that changes in some way (preferably the text)when the end activity date has passed. So an activity runs from January to June 05, on the 1st July the other field goes from saying 'Pre Activity' to 'Post Activity'.

Regards

Ian

Answer
Yes and no. What you are really asking is if you can display a message when the End date has passed. Since this is essentially a calculation you do not need (and should not) store it in your table. This can be displayed in a control on a form or reports as needed and calculated on the fly.

The expression:

=IIF([EndDate] < Date(),"Pre Activity","Post Activity")

will do what you want. Just use that as the Controlsource for a textbox on a form or report.

HTH
Scott<>