Search results

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! :)

same way! it is a procedure that is run when it is needed. Thanks Mary

I received the data from a .csv file extracted from a website. The db read it and place it in a table in the db with the same format as the .csv file. There is no data entry needed. thanks :)

I forgot to add that I received the data from a .csv file extracted from a website. The db read it and place it in a table in the db with the same format as the .csv file. There is no data entry needed. Thanks Mary

Thanks, Plog to replying. The number of subjects change per student, currently the max is 11 subjects per student, but there are some students that have only 8 or 9. The school plans to add more subjects but are not sure how many or when. So, almost half of the table is empty. In the future...

Hi Everyone: I have reviewed many post about converting columns to rows and still does not get it. :banghead:As you might imaging, I am new using access. Please, need help. Here is what I would like to do: I have a table which want to normalize. Table Name: FlatFile This is the fields list...