My database is used to track the number of days that a car is parked in a garage and make sure that it doesn't exceed 50 days per year.

I use three forms on my main entry screen all based on their applicable table.

On one of the forms, I use a field listed in the table to calculate the total number of days by using datediff fuction. However, the result doesn't save to the table. What must I do to save this data?

This is my first database, so bare with me.

Thanks

it is not a good idea to store calculated values in a table use a query and base the form on that.

I'm sort of at the end. Is there an alternative?

How do I create the query criteria and what are the steps for creating a popup message on a form that states "vehicle exceeded permitted number of days" based on the calculated field?

I hope this isn't too complicated. I have no idea.

I assume the field calc. result is displayed on the form in which case it is not necc. to store it in a table, and the text box is called Text5, create a large warning label of your choice and add it to the form on which the calc field is displayed add the following code to the on current
IfMe!Text5 >50 Then
Me!Label1. Visible = True
Else:Me!Label1.Visible = False
EndIf


[This message has been edited by Richie (edited 08-01-2000).]

[This message has been edited by Richie (edited 08-01-2000).]