This worked out perfectly. Thank you again,
Patti
patriciashoe
Last Activity: Apr 18 '08, 01:37 PM
Joined: Feb 10 '08
Location:
-
THanks,
Here is the code:
Code:=IIf([strudent_enroll]=0,0,compute([staffingDivisor],[strudent_enroll],[teacherfte],[sixth_grade_enroll]))
I need to apply some additional logic against this number. Compute is a function I wrote that does some basic maty based on table values. This code produces a number, for example 25. I need to take 25 and apply some further logic to see where 25 compares on a scale...Leave a comment:
-
Form Text box calculations extended
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 this value in the new form text box? Do I h ave to repeat the control source from the first text box to perform the calculations in the new textbox? Thanks,... -
Stewart:
Thank you!!! THat worked very well. I made a few adjustments to suit my design. Thank you for for your time and effort. I certainly appreciate the effort.
PattiLeave a comment:
-
Thanks for the quick reply. The variables are not translating. I believe I read somewhere that you can use the cstr() function to turn them into strings which adds some complexity to the resulting string. I have been using a message box to check the string. Any suggestions on how to tweak your string? thanks again,
PattiLeave a comment:
-
Building SQL string need guidance
Good AM:
I have struggling with constructing a string to execute some SQL. Here is my update statement
update teacherresource s set [student_enroll] = (([student_enroll] / variable1) * Variable 2 )) where(( trschool_id = 12 and [tryear] = forms!form1!yea rcombo) or (where trschool_id = 13 and [tryear = forms!form!year combo))
the variables are both numeric. I know the variables have to... -
Thanks for the reply. Here is what I am trying to do.
TeacherFTE num
trSchool_id num
grade_subjectid num
tryear text
strudent_enroll num
displayorder text
the primary key is trschool_id + grade_subjectid + tryear
Enrollment
Enroll_data num
Year text
Er_school_id num
These tables are not directly related. The strudent_enroll...Leave a comment:
-
Update Set Statement problems
Everything I read indicates the following statement should work. What happens is that any field after the where clause gets treated as a parameter by Access. Even if I supply the data the query fails. Any ideas? Thanks, Patti
...Code:UPDATE teacherresources SET teacherresources.Strudent_enroll = strudent_enroll/(SELECT sum(enroll_data) FROM enrollment WHERE teacherresources.trSchool_id = enrollment.erSchool_id and year='2007-2008')*(SELECT
-
Update Statement Syntax error
I have been struggling with this update statement. At this point I get a syntax error if i go from SQL view to design view. Can anyone spot a problem?
UPDATE teacherresource s AS A
SET A.student_enrol l = student_enroll / SELECT sum(enroll_data ) FROM enrollments B WHERE A.trSchool_id=b .er_School_id and b.year='2007-2008') SELECT sum(enroll_data ) FROM enrollments WHERE a.trSchool_id=b .er_School_id and enrollments.yea r='2008 -2009')... -
HOw to UPDATE programatically
Good Morning
I have a table as noted below.
Schoolid num
Gradeid Num
TeacherFTE Num
Student_enroll Num
year text
The primary key is made up of gradeid, schoolid and year. The application loads two years worth of data. For example, for each record in 2008 there is another for 2009. Several of the schools require that a formula be applied to... -
Help with advanced query
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:
<Grade/SubjectName> <Sum of Teacher FTE> <Sum of Enroll> (by school_id)
Report would like like this.
It seems to me I should be able to create this...Code:Grade School A School B 1 4 100 5 125 2 ………
-
Need Report similar to a pivot view
I have need for a report that that I can almost obtain in a crosstab query. The query I am reporting on is structured as below:
Schoolname text
Gradename Text
Gradeid Num
Schoolid Num
TeacherFTE Num
Student_enroll Num
I need a report that is structured with the schoolnames in columns across the top and gradenames as row headings. Under each school I need to report teacherFte... -
Finally got this to work by duplicating the code I had in the update event of the combo box to the got focus event of the same combo box. When I open the form and navigate to the subform the got focus event kicks in.
PattiLeave a comment:
-
Sorry. my head uis turnig to mush today. Here is another example of the code that I misstated.
Forms!schools1! enrollmentsub.F orm.Filter = "[year]='" & Me![Combo46] & "'"
Forms![schools1]![enrollmentsub].Form.FilterOn = True
The public variable has been placed in the combo box with the following code:
Me![Combo46].Value = get_holdvar()
ThanksLeave a comment:
-
FIlter form and subform an open form event
Greeting All
I have several public variables which I use to build a filter string that I would like to use when I open a form and several associated sub forms. I have set the value of the combo box on one of the subforms with this variable. I have not yet figured a way to have the update event code on the combo box run automatically, so I put the following code in the open statement of the main subform. Here is some current code:... -
Thank you!!! Everything is working just fine. I did take note of your advice about proper naming.
Thanks again, PattiLeave a comment:
-
Sorry for the confusion. Here are the data structures I am using:
Code:Table = [[U]TeacherResources[/U]] [I]FieldName; Type; Index[/I] BuidlingID; Numeric TeacherFTE; Numeric Enroll_Students; Numeric Tr_Year; Numeric SubjectID; Numeric; FK
...Code:Table = [[U]Grades[/U]] [I]FieldName; Type; Index[/I] SubjectID; Numeric; PK GradeName; String BuildingID; Numeric FormulaID; Numeric Divisor;
Leave a comment:
-
Sorry if I am not being very clear. I guess I am looking for the easiest way to use these formulas in a text box based on a record in the table. If I have a numeric field called formulaid for each gradeid, then how do I indicate what formula should be in the text box calculated value?
table data example
gradeid numberic
gradename text
buildingid
formulaid
For example:this is what...Leave a comment:
-
Gents:
I have coded my formulas and have test them. Can you suggest way that I can code the following:
In my grade table I have a field that would indicate which formula is to be used. On my form and my reports I would like to use this field to programatically set up the function. For example, for gradeid 7 the formula would be "MAIN". When the report runs I need to have the calculated value reflect that...Leave a comment:
-
Thank you both!! I am on my way.
PattiLeave a comment:
No activity results to display
Leave a comment: