Recent content by terrytek

Where do I put that query or SQL statement in the Property Sheet of the combo box?

I have some combo box fields on an input form that, now that I've used them, it turns out would be easier to use if I had them sorted in reverse order. These fields are both based on tables, not queries. Is it possible to change the sort order of the combo boxes? I have changed the sort order...

I have uploaded a demo database with the relevant info. I want the data to look like the report that is in the database (there is only one). The figures in that report now are only correct for the 2018-19 year, because if someone was posttested in both AY2019 and AY2018 (in other words, their...

I already have this, but it doesn’t solve the issue, because when you have a test that is not a student’s most recent test, it can sometimes be both a pretest for the most recent test and a posstest for a previous test. Labeling a test as pretest or posttest doesn’t work because if there’s...

Please see reply to plog for a demo db with the relevant data. There is no expiration date, so the test sets would be 1/1/16 is pretest, 1/1/18 is its post Then, 1/1/18 is pretest, 1/1/19 is its post So I don’t really know how to handle how to tell the database to compare those tests...

I already have queries that compare the last two tests that a student has had. This works fine for students in this year, but does not work for students who have had tests in previous years that can be considered post-tests (i.e. they have a test that was a post-test this year, which the...

My database stores information about an educational program that runs on the academic year. I need to show how many students had posttesting, i.e., they had at least two tests to compare. I need to have the posttesting data for each academic year on a report. The database goes back to the...

Thank you! Declaring my column headings made the query run! Much appreciated!

Yes, both queries work.

I am trying to make a crosstab query using the following query as a basis: SELECT qryTwoLastTestsAWValues.StudentID AS StudentID, qryTwoLastTestsAWValues.L.TestDate AS LastTestDate, qryTwoLastTestsAWValues.P.TestDate AS PrevTestDate, AcademicYr([LastTestDate]) AS AcademicYr...

Yes, that's obviously a much better way to do it. My way is what happens when your VBA skills are so rudimentary!!

Yes, it turns out that I called the variable I was trying to find the same thing as the function in the other modules I had, while in the thread in this particular case, the variable AcademicYr did not match the function name TestToAcademicYear. That's a good thing to know!!

I did that, and it worked. The odd thing is, though, I've written other simple functions and never needed that before. I don't really understand why those worked and this didn't.

I have a query where I am trying to convert a test date into the academic year in which it occurs. SELECT qryTestingMostRecentTest1.StudentID, qryTestingMostRecentTest1.LastTestDate, qryTestingMostRecentTest1.PrevTestDate, TestToAcademicYr([LastTestDate]) AS AcademicYr FROM...

SELECT tblClasses.Class, tblTesting.StudentID, qryStudentsExtended.StudentFileName, tblTesting.TestDate, tblTesting.NextForm, NextFormEven([NextForm]) AS NextFormEven FROM tblTestType INNER JOIN (((tblStudents INNER JOIN qryStudentsExtended ON tblStudents.StudentID =...