Search results

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

Thank you so much for your help. The outer join was the key to my getting it. I had to play around with the underlying query to get it updateable but was finally able to do so. Much appreciated!

But how do I get a list of students in the class to show in the subform? The table bound to the subform is empty until data is entered into it.

I looked at this and tried to determine how you had structured things, but I am not advanced enough with Access to figure out how to get where I need to be from there. Is there something you could refer me to to read to learn how to do that, or could you give me more instruction? Thank you.

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

That threw an error "Error in TRANSFORM statement", but I appreciate the try.

Worked a treat, after I finally got the query properties to open instead of the field properties! Thank you!

I have a table that has Gender ID (Autonumber type) 1 is m 2 is f 3 is unspecified I have three reports based on similar sets of data. Two of the datasets contain some Gender ID= 3, so they seem to...

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

Thank you so much for your reply; this was driving me nuts and I never would have figured this out on my own. I designed the db, but this data was entered by the user. Could you give me more detail about "use the Asc function"? (I tried doing the Asc function on the SS field in a new query, but...

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 actually looked at the reference above before I posted here, but when I change =DLookup("[EducationalFuncLevel]","tblNRS","[NRSLevelID] =" & [Forms]![sbfTests]![NRSLevelID]) to =DLookup("[EducationalFuncLevel]","tblNRS","[NRSLevelID] =" & [Me]![NRSLevelID]) I not only get the "#Name?"...

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

Not sure what you mean by drilldown by selecting ClassDate; the date can be any date; would not likely be a date already in the table? For the second method, what would I use as the record source for the form I would be opening?

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