Recent content by watembo

Sorry for the late reply. The name field is in a combo box unbound name=SName. Afterupdate it should display the corresponding <LUpdate>, <LClass>, <Status> and <StudentID> from qryStudLong. This works well but I need to update data in tblStudLong from where the above query was drawn based on...

Sorry about the data. I have attached

Thanks, First Query SELECT tblStudLong.StudentID, Last(tblStudLong.DateUpdate) AS LUpdate, Last(tlkClass.Class) AS LClass, tlkStatus.Status, tlkClass.ClassID FROM (tblStudLong LEFT JOIN tlkClass ON tblStudLong.CurrentClass = tlkClass.ClassID) LEFT JOIN tlkStatus ON tblStudLong.Status =...

Thanks vbaInet. After some literature this is what I finally did and it worked: Private Sub SName_AfterUpdate() DoCmd.ShowAllRecords Me.Recordset.FindLast "StudentID = " & Me.SName Forms!frmStudLong!SName.SetFocus End Sub Only problem that if it doesnt find the record it shows...

Thanks vbaInet. I would appreciate something more specific since what I have searched doesnt quite answer my dilema. "last update" is simply the last record that was updated.

I have a student database and I want to update class manually as the students graduate each year. In my form I want to search the name of the student and retrieve records from last update from a query I have created. To find the record, I search from a combo box with a code...

Thanks for your patience. My example is in post number 8. If I remove the WHERE option what I get is the message "At most one record can be returned by this subquery". I understand subquery works with only one record at a time. I have almost 3000 records which I want to match date of visit with...

I just want to return all records in the database. Presently I have filtered for only one record.

The subquery worked absolute magic! After this, SELECT tblvisit_information.patient_id, tblvisit_information.visit_date, tblvisit_information.next_visit_date, (SELECT TOP 1 Dupe.next_visit_date FROM tblvisit_information AS Dupe WHERE Dupe.patient_id=tblvisit_information.patient_id...

Sorry guys. I corrected my SQL to a simpler SELECT tblvisit_information.patient_id, tblvisit_information.visit_date, tblvisit_information.next_visit_date, IIf(DCount("next_visit_date","tblvisit_information","visit_date = #" & [next_visit_date] & "# And [patient_ID]=" &...

Thanks alot good people. For G37sam my thought is that it would mean redesigning the form to check if the appointment was honored. bob fitz SQL returned an error Invalid bracketing of name '[tblpatient_information.patient_ID]' and most were no's . The full SQL is like this: SELECT...

I have two columns: date of visit and date of next appointment. I would like a query that match the two to see if patients are coming on their appointment date. eg patientID visitdate nextapp 1 20/3/12 29/4/12 1 28/4/12 30/5/12 1 30/5/12...

I am watembo from Kenya. This website has always been first whenever I search for help in access programming. I am happy to join. I am not so good at programming but I can do alot of basic stuff on my own. I rely on this community of experts to make me an expert too :)