Search results for query: *

I have a textbox in a form that is derived by the use of a function that I created. This is working just fine. I now have the need to take this value and apply some additional logic to the value to determine a new value for another form textbox. The question - what is the best way to refer to...

Thank you all. I finally got it working and learned a great deal as well. Many thanks,Patti

Using a simple exmaple, the result in the IW looks like this UPDATE TeacherResources SET [student_enroll] = v2 The value of v2 = 25 so I would expect that the update statement should look like: UPDATE TeacherResources SET [student_enroll] = 25 Otherwise I am prompted for the value of the...

Thanks for all the quick responses. One problem, I need to pass than value of the variable into the string. In this case it is numeric. When I use the immediate window I would expect to see the numerics that will be part of the string. Otherwise, I get prompted for the value of the variables...

Good AM: I have struggling with constructing a string to execute some SQL. Here is my update statement update teacherresources set [student_enroll] = (([student_enroll] / variable1) * Variable 2 )) where(( trschool_id = 12 and [tryear] = forms!form1!yearcombo) or (where trschool_id = 13 and...

Actually, that is how I have the teacherresource table set up including the primary key. I am entering data and producing a number of reports. My difficulty is determining how to produce the report I initially mentioned. I want to produce a report by school type, easy enough. The report will...

Yes, in grade 1 there are 4 teachers and 100 students. Steve

Thanks for the help. SIxth_grade_enroll is a work around for a complicated formula problem. It is used sparingly. The principals here do not get transfered - this is bascially static data. Displayorder is used to make sure the grades print out in an order that I have determined as opposed to...

I am trying to determine if I can create a select query that will produce the following data for a report. I would like a report/query that is organized as follows: Gradesubjectname Sum of Teacher FTE Sum of Enroll by school_id Report would like like this. School A School B Grade Grade 1 4...