Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: PatriciaShoe
- Content: Threads
- Order by date
-
textbox 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...- PatriciaShoe
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
Building SQL String - confusion
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...- PatriciaShoe
- Thread
- Replies: 14
- Forum: Microsoft: Access Modules (VBA Coding)
-
Ned advanced Query to build rpeort
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...- PatriciaShoe
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
