| re: Calculate Date Difference and display message box
jbsfe wrote:[color=blue]
> I have a table used to enter the last date a project was updated.
>
> When updating via a form, I need to compare the new date against the
> last date in the record. If the difference is greater than 14, I need
> to display a message box alerting the user. Secondly, they must then
> enter comments in the comment field explaing the varience.
>
> I'm not sure how to get the last value and compare it to the current
> value.
>
> Any help would be greatly appreciated.
>
> Thank You,
>
> Jimmy[/color]
DMax("DateField", "TableName", "Criteria (if needed)")
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
| 
