Search results

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...

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...

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...

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...

I am trying to use a date field in my query to sum hours after that date by using a "where" expression. SELECT tblClassAssignment.StudentID, qryTestingMostRecentTest.StudentFileName, tblTesting.TestTypeID, Max(qryTestingMostRecentTest.TestDate) AS MaxOfTestDate, Sum(tblClassHours.ClassHours) AS...

I have the following query, which I want to return ONLY the most recent test date: SELECT qryTestingMostRecentTest.StudentFileName, Last(qryTestingMostRecentTest.TestDate) AS LastOfTestDate, qryTestingMostRecentTest.NextForm, qryTestingMostRecentTest.Class FROM qryTestingMostRecentTest GROUP BY...

I need to find instances of students that have three or four tests by their three or four most recent test dates. Is there a way to query with that criterion? Thanks.

I have a memo field on the form. I type into this field sometimes, always in English. When I look at the table now, a few of the fields appear as I typed them, but many of them have what looks like a Chinese character followed by a symbol: ex. 됏 . The Chinese characters do not all look the...

I have a form with two combo boxes that populates a subform based on the values in those combo boxes to show some data. I need to do the same thing with another set of data, except I need the combo boxes to populate the subform, but then allow me to enter data for each record, and then write...

I have a series of three reports with similar data. One of the fields is Gender, and it has three possibilities: m, f, or unspecified. My problem is that one of the reports' underlying queries does not return any records with the value "unspecified", since none of that particular recordset have...

I have a field on a form that I needed to make a combo box instead of a text box because of data entry irregularities. I followed this procedure to make the combo box, since the Combo Box Wizard doesn't seem to be working...

I have a union query for two unrelated tables: SELECT PairID, "Pair" AS [Relationship],StudentID,AcademicYr FROM tblPairAssignment GROUP BY PairID, StudentID, AcademicYr ORDER BY StudentID UNION SELECT AssignmentID, "Class" AS [Relationship], StudentID, AcademicYr FROM tblClassAssignment GROUP...

I have a qryMostRecentTest where I was using LAST to get the latest date. Due to LAST returning unexpected results, I changed it to MAX, and now it works correctly by returning the most recent date. There is another qryStudentTotalHoursSinceLastTest that uses this MaxOfTestDate. When I try to...

I have a query (qryTestingValComp) where, occasionally, a test score [SS] will have a plus sign, i.e. 208+ . I need to get the difference between two test scores, so need the score converted to a number. I have used the Val function: SSNum: Val(Nz([SS]))However, there are currently two cases in...

I have a sbfTests with testing information. One of the text boxes has NRSLevelID, and I need to look up the corresponding text value EducationFuncLevel in the tblNRS (because this subform is also used for data entry, I cannot pull the text values into the query qryTestingUpdateable underlying...

I need to have a form that shows a list of students sorted by class and allows me to enter hours and a date for each student, i.e. the list of the students would be in datasheet-like view, with empty fields next to each student for DateReported and Hours. Then I would click a command button and...

Dear all members of the Access World Forums, I come here for help a lot, and I have received a ton of great help from people who take the time to explain things to a newbie, but this forum even helps me when I don't end up posting. Many times I've typed out a question to post, and just seeing...

I am trying to run a parameter query to return results where one of the fields (TotalHours) is greater than or equal to the parameter. If I run the query without the parameter, it gives the expected values, but when I run it with the parameter, it is returning only some of the records, but they...

TRANSFORM Count(qryDemogForCrosstab.StudentID) AS CountOfStudentID SELECT qryDemogForCrosstab.Classification, Count(qryDemogForCrosstab.StudentID) AS [Total Of StudentID] FROM qryDemogForCrosstab GROUP BY qryDemogForCrosstab.Classification PIVOT qryDemogForCrosstab.AgeGroup; Result is...

Query: SELECT tblTesting.TestID, tblTesting.StudentID, tblTesting.TestDate, tblTestType.TestType, tblTesting.Form, tblTesting.SS, tblTesting.GE, tblTesting.NextForm, tblTesting.Memo FROM tblTestType INNER JOIN tblTesting ON tblTestType.TestTypeID = tblTesting.TestTypeID ORDER BY...