Toddski

Ahh light bulb! I see exactly what you are saying. I can write a script to empty the global when the database opens. That is what is suppose to be in the global in the first place. Thanks.

Well it helped slightly with my understanding however this database is now hosted in a FM server so the session ends when they log off and the globals should reinitialize when they start again. For some reason the globals are not reinitializing.

I inherited support for a database and a user deleted some data that I then restored from a backup. Well, now I have a global field that has data immediatly when I open the database. I ran a design report and that field is not set until you run the script set for exiting the database. Why does the global field now open with a default value? Thanks Todd

How the heck did I miss that one. Works great! Thanks

Background: I have a survey database for our company. It surveys employees about their training needs. We ask employees to rank how often they use a particular software and how important training would be. I have created summary fields that give me the Averages of importance. Now I want to display the data in a report. I have a sub-summary section when sorted by Training Program name that displays the Avg of Importance for each training program. The problem: I need a field that is calculated based on the Importance average Summary Field. If the average is between 4 and 6 display "Important." If the Average is between 6 and 10 display "Very important." Case and If statements do not seem to work because when you look at the report I always get "Important." I believe the problem is that my calculation field is not a summary field but you cannot write a custom summary field. So is there a way to use a calculation in a sub summary? Thanks, Todd