Compare date, when date is today, change other fields

#1 (**permalink**) 28-Jul-2006, 08:28 AM

Hi,
I have a task tracking database. When a task is on hold, say for a week, the
fields would be be set up like this...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12382-compare-date-when-date-today-change.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12382
[Assigned_to] To Be Assigned
[Status] Hold
[Priority] Hold
[Due Date] e.g. a week from today

When the [Assigned_to] field is "To Be Assigned", I need it to compare the
dates so that when the [Due date] = today it will automatically change the
fields to
[Assigned_To] Linda
[Status] Assigned
[Priority] URGENT
[Due Date] to today

Do I need to do a query for this, or can I somehow code the field to perform
this comparison and changes?

Thank you!!

#2 (**permalink**) 28-Jul-2006, 08:28 AM

You need to use an update query and have criteria for the [Due Date] field
like this --
<=Date()
Have the query run from a macro named Autoexec so that any time the database
is opened it checks. By using <= it checks if past due as the date could
be set for a holiday.

"TxVics" wrote:

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12382
> Hi,
> I have a task tracking database. When a task is on hold, say for a week, the
> fields would be be set up like this...
> [Assigned_to] To Be Assigned
> [Status] Hold
> [Priority] Hold
> [Due Date] e.g. a week from today
>
> When the [Assigned_to] field is "To Be Assigned", I need it to compare the
> dates so that when the [Due date] = today it will automatically change the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12382
> fields to
> [Assigned_To] Linda
> [Status] Assigned
> [Priority] URGENT
> [Due Date] to today
>
> Do I need to do a query for this, or can I somehow code the field to perform
> this comparison and changes?
>
> Thank you!!