Recent content by marysilvaramos

Thanks to both for the replies! I am testing both versions. Thanks again for the help, Mary

Thanks John for the reply! Is there anyway to find the number in a query? I am using a query to get the value and use it in a formula. Thanks Mary

Hi: I should find the position of a number in a sentence and later extracted. The number is attached always to an "E". ie: E1, E2, E3,E4. The range of the number is 1-4. I have this until now: X: InStr("E[#]",[Col1_Comment_1]) but it always return 0 Please, may you tell me where is the...

Thanks Pat again! I am working on it! I noticed that the field Me.[StudentName] (combo box) is empty in the form but always shows in the debugger the first Student Name in the list. So, when the line strStudentName = IIf(Me.[StudentName] & "" = "", Null, "StudentName = '" & Me.[txtStudentName] &...

llkhoutx Thanks for your reply but i did not understand what your mentioned. ok Pat! it worked wonderful. now I need to add the student name. I have the following: strWhereQuarter = IIf(Me.[Quarter] & "" = "", Null, "Quarter = '" & Me.[Quarter] & "'") strWhereSchoolYear = "SchoolYear = '" &...

Thanks a lot, Pat Hartman!!! It worked BEAUTIFUL!

Hello to All: I am trying to filter a report using a form. The form has the following combo boxes (until now) to filter the report: txtSchool Year (ie: 2012-2013) numQuarter (ie: 1,2,3,4) txtStudent Name (ie: Doe, jane) Now, the search options include all the fields, one or more fields or...

Thanks for your reply! I figured out what you mentioned. I am running out of time. For now, I am trying a mail merge from access to word. There are some issues also to resolve doing it... :(:confused: Thanks again, Mary

Sorry, the file did not upload. Here it is..

Thanks for your reply, Apr Pillai: It is amazing! There are some changes on the format. Attached is the file: comments should be per subject and teacher per quarter, the grade and percentage per subject and teacher per quarter should be included too. Thanks again, Mary

Thanks Apr Pillai: It worked wonderful! Now, the report should include other fields like teacher name per subject, grade per subject (in letters: A, B, C, etc), teacher comments per subject. How can they be included in the query? Thanks again, Mary

Hi to All: Happy New Year! I guess somebody else have had this issue before. A report needs to be created for a school it should print like this: Student Name .............. Period 1. Period2 . Period3.. Period 4 Subject1 Gradeq1 Gradeq2 Gradeq3 Gradeq4...

BEAUTIFUL!!!! :) :) Thanks a ton! Mary

Happy New Year, Plog! I am working on the code you sent and received the following message: " Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' or 'UPDATE' " Here is what I wrote: SELECT StudentID,Col1_Grade_Period, Col1_Class_Name_1 AS Subject, Col1_Teacher_1 AS...

i will try it and let you know! thanks plog! :)