×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

(OP)
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,"* *ALERT* *"," ")
the formula for the days to go box:=[Cal Due Date]-Date().
Days to go is based on a text box labeled "CAL DUE DATE"
cal due date is based on a text box labeled "INTERVAL"
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 "CAL DATE".
The cal due date is automatically calculated based on the "INTERVAL".
The "ALERT" comes up in the form text box if the "DAYS TO GO" box indicates less than 31 days to go.

My problem is that the word "ALERT" 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

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

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close