Bound Text box and Tables, Queries and Reports???

[csegal]

I have a text box labeled "ALERT" based on a calculated
text box labeled "DAYS TO GO" the formula for the alert box:
=IIf([Days To Go]<31,&quot;* *ALERT* *&quot;,&quot; &quot
the formula for the days to go box:=[Cal Due Date]-Date().
Days to go is based on a text box labeled &quot;CAL DUE DATE&quot;
cal due date is based on a text box labeled &quot;INTERVAL&quot;
The formula for cal due date:=[Cal Date]+[Interval]
How everything works is: when a tool is calibrated, the new date is entered into the text box &quot;CAL DATE&quot;.
The cal due date is automatically calculated based on the &quot;INTERVAL&quot;.
The &quot;ALERT&quot; comes up in the form text box if the &quot;DAYS TO GO&quot; box indicates less than 31 days to go.

My problem is that the word &quot;ALERT&quot; is not showing up in the report or the table or the query???
I hope I gave enough information.
I can be reached at
csegal@fineair.com

 

[PamelaG]

Hi Csegal!

If I understand your question correctly, then you have created this new calculated field on a form -- yes?

I always recommend that such calculations be done in queries for this very reason. When you locate calculations in forms or reports they cannot be used elsewhere without being duplicated. Query-based calculations, however, can be displayed in other queries, on forms and in reports.

You DON'T want to store calculated values in your tables!

So the answer is to go back to the query this form is based on and add the field there. Make sense?

Pamela

http://www.accessinsight.com