Veronica

Dan, I'm experiencing a similar problem with a summary field that won't calculate/summarize a calculation field in the sub-summary part. For instance: I want to summarize a calculated "Age" field. Let's say I have 2 age groups, 17 and 18. In reality I have 27 members of the age 17 group and 19 in the age 18 group. My summary field returns a total of "1" for each group. The summary field is in the sub-summary part and sorted by the "Age" field. The layout is based on an enrollment table and the age fields, (calculated and summary) are in the Contact table. I'm having a severe senior moment, please help. Thanks.

This is so simple but I can't figure out what is wrong. I have a field: "Gender". It is a drop down value list consisting of "F" & "M". I have two other calculated fields with a text result (and stored values). The if statements look like this: Female field: If (Gender = "F"; "F"; "") Male field: If (Gender = "M"; "M"; "") Neither of them are working. No values are returned in any record. I have used this type or style of calculation field in several other fields and databases successfully and I cannot figure out why it is not working here. This is so frustrating.

Yes, I agree about the date formatting but as you imply it doesn't make sense why a wrong date would be posted there. Additionally, not matter what date you enter in that field in the data entry form, it always prints out with that one specific date. However, as I said, when I took that field outside the text box it worked just as it should with the correct date. Go figure. :shocked:

Sorry it took so long to provide some feedback. Stuff happens, right? I double checked as you sugested but everything looked okay. However, I played around some more: First I changed the date field to display as entered in the data entry form view. Next, I removed the date field from inside the text box of my Form Letter view and placed it separately and above the text box. I formated the field to display the way I want it to. And lo, it worked. Putting the field and specifying a certain type of formatting for the date does not work inside a text box. Go figure. Thanks for your help.

I originally developed this file in 8.5 Adv but recently started using 9 Adv for maintenance and new development. I have an older database, (dev'd in 8.5), with a date field where you can enter a date such as: 5/19/2008 and it will display as May 19, 2008. This display is okay but the strangest thing happening is that this field is somehow locked into displaying a wrong date! It is showing "May 8, 2008". I can enter and change the date in the field but it always displays "May 8, 2008". Any ideas what is happening? :

Thank you all for your advice and support. I just don't understand why this should have been so difficult. I am using a summary report with a couple of sub-summary parts already and I am summarizing other value lists successfully without individual sub-summary parts. I have one sub-summary part where I am summarizing Grade Level, Age Group and Ethnicity and it is producing accurate results for these categories. Just the gender value list wasn't working and couldn't understand. I will try another sub-summary part first before the other suggestions. Like LaRetta, I am for simplicity. Again, thank you all. :smile2:

All I want is the total number of "F's and the total number of "M"s. The source field is called "Gender" and it is a radio button display of "F" and "M".

I have looked all over for a solution that should be fairly simple. I don't know if I am asking the wrong questions or not understanding the posts I've viewed. What is so hard about summarizing a simple two value value list? It is for specifying gender. The value list is "F" or "M". If you can't summarize a value list what is the point of a value list? I have spent hours and hours on this problem without success. I have tried extracting "F" to an intermediate field called "Female" and "M" to an intermediate field called "Male" but this no longer works and I don't know why. It worked in an earlier 8.5 version of the database. Shouldn't this be a simple operation?

This morning I opened my Student Information System which is being kept on our FM server 8. It has muliple tables but I ran a search on the enrollment table for records created between certain dates using an extraction layout that also captures some related student demographic data. As I scrolled through the records I noticed that some of the enrollment records were missing the students data. As I continued scrolling throught the enrollments records more and more student records began to disappear. Fortunately I capture the student ID number in the enrolment record. So I began to write down a few of these Student IDs where all the Student demographic information was missing. I went into the Student table and started to look for these student records by doing a search on the student IDs. To my horror, I discovered that those student records had completely disappeared. I opened my server admin program and checked a variety of things. On the system messages I got some information that, (I'm away from the office so I don't remember exactly the warning I saw but...), it said something about too many attempts to connect to something else. Additionally the message indicated that a malicious program may be running. When I left the office IT was running a diagnostic on the server to see if any malicious programs were indeed running. Unfortunately I won't know until I go into the office in the morning. But does this problem sound like something similar to anything anyone else has experienced? Thanks in advance for your help.

I just downloaded FM9A from a Maintanence Agreement Release upgrading from FM8.5A. It seemed to install OK but now I have 4 shortcut icons that launch 8.5 and I have to launch 9 from the Start dialog - All Programs. Is it safe to remove 8.5 Adv and delete all the shotcut icons or do I need to keep 8.5 Adv?

My apologies to all who tried to get into my database example. I no longer remember the password I created to supposedly allow you access. I suspect that I'm writing this to an audience that has already moved on and other commitments on my part have caused me to give up on this for a little while. If you are interested contact me at: vpalmer@smcoe.k12.ca.us Sorry and Thanks

My apologies to those who may have looked at my database and didn't get very far. The user name should be: test1 and the password admin I think that should let you see all around the database and maybe help me solve my problem, (which has not yet been solved). Stu_Info_Sys.zip

I cut out a lot of the scripts. There are 3 test scripts that are appropo for this thread. There is a script section for them, "Test Report Scripts". The buttons for this exercise are Wheat or Peanut Butter colored. And the login is Test2, password is test2. Stu_Info_Sys.zip

I'll work on it. Give me a day. Incidently, after I posted my last reply to you I got a request for a report from the other database. I changed the source of the local variable before running the report. And it dawned on me that the global field is in one table and the report data was from another table and it all worked perfectly. It seems to prove that the global field & local variable AND the report data don't have to be in the same Table occurance. Thanks. Does anyone out there have any other output determination techniques?

Hi Comment, Thanks for your help also. I appreciate the tip concerning just using the global field itself as the scriptparameter. I wish I could send a copy of the database but it is a copy of a version in use now and developed at a time when I knew much less than now. As the new school year is beginning I am cleaning up old techniques with new stuff I'm learning about. As this whole exercise. I changed the source of my local variable to the global field itself. I removed the scriptparameter from the script button. I executed the script with the option to produce the report saved as a PDF and using the script debugger, I watched the script just march right over the: Perform Script "PDF Script". I currently have over 300 scripts that if I could find out what is wrong with this script and process could help me reduce the number of scripts by 75-80%. Most of the existing scripts are for producing reports in different formats. As you may surmise, it is so frustrating because the technique is working fine in the other database. The only thing that is different here is the file and table names. Thanks for your time.