Search results

I've a table containing staff names, another table containing the occurrences of the staff names with a date. For example, tblStaff -> StaffKey, StaffName, tblSOccurence -> StaffKey, ActivityDate tblStaff StaffKey StaffName 73938 Ah Ong 93948 Owe Tam 94331 Weng Housin...

A report in which unique teacher name list for each student group.

Great! Pls. read the attached database Thanks in advance.

Great! Thank you very much.

Hi I've a field name called "DtTeach" type Date and is set to medium date as "dd-mmm-yy". e.g. 10-Nov-16. I do a look up into the same table with the following DLookup and got the date whose format is 11/10/2016. However, I got run-time error "3021": No current record. Actually, I...

It works. Thanks.

I’ve several tables in a database, the tables’ structures and sample data (partly extracted) below 1. tblTutor – Tref, Name, First Name, Alias, District, Interests. Key: TRef 2. tblTAppt – UID, ApptStart_Dt, ApptEnd_Dt, Company, TRef (Foreign key) 3. tblTAssign_FPA - TRef, AcademicYr...

Hi, I'm working on DLookup with 3 criteria in the following scripts Dim iRoatation, iSession as integer; iRoataton = 1 iSession = 1 DLookup("[Session]","tblTAssign_FPA","[AcademicYr] = " & txtApptYr.Value & " AND " & [Rotation] = iRotation & " AND " & [Session] = iSession &...