Search results

Thank you for the advice. I still have difficulty in resolving it. Anyway, I put the application in Dropbox as at https://www.dropbox.com/s/jhis7726ufxngyx/DuplicateStd.accdb?dl=0 as it's too big to be attached. I notice that the query is in question. It pops for "Enter Parameter .." when...

I've tried SELECT DISTINCT but I still fail to get rid of duplicated records.

Sorry. The screenshot is attached. Regards.

Hi, I've a query "qryTS_Assigned_PIP1" below to report the tutor-student map. I notice that tblTAssign_PIP is fine for the assignments but I encounter a problem of duplication of the teacher-student assignment with the following query. SELECT tblTAssign_PIP.TRef, tblStudent.SUID...

Thank you. It worked perfectly.

Hi, I've a query with columns TRef (Primary Key), SQuota, SPSQuota, SessionCnt. I need to build a query to apply the below criteria and then sort them in order of effectiveQuota. if (SPSQuota x SessionCnt) >= SQuota then effectiveQuota = SQuota else effectiveQuota = (SPSQuota x...

Thank you for the information. It worked perfectly. Best.

That's great! For example, invoice_Dt is 22/2/2016 and today is 05/05/2018. The duration is 2 years 2 months. How can I calculate with sql? Thanks in advance.

Hi, I want to build a query in ACCESS to calculate a duration between today and invoice_date. I built it as follows SELECT DATEDIFF(MONTH, Date(), Invoice_Dt) AS [Month DatePart], DATEDIFF(YEAR, Date(), Invoice_Dt) AS [Year DatePart] FROM tblEquipment However, it prompted Month...

That's. I inspected the codes line by line and applied minor changes. There's a possibility that the actual attendances of the tutors (the criteria stated before) is below 241 student number. My next step is to examine those students' sessions which the tutors do not attend. Any...

Thank you for your work. The program codes have been examined and re-examined but still can't find out a bug. Would you give some hints on this. My program code works on a few keys' conditions, SUID is only for assignment once the condition is satisfied. Besides, SUID contains all numbers...

Individual declarations were made, however, the output count is still below the expectation. Welcome any idea on this.

All variables are explicitly declared. My work is to assign the suitable tutors to 241 students NOT 207 students as the program outputs. There're 688 sessions available among the tutors for the students. My work only did 172 numbers of tutors count for the students.

There are some criteria Each tutor states the number of sessions he/she is available for teaching, there're 25 sessions in year 1 for selections. In each session, the tutor states the number of students he/she can take, usually 1 student or 2. The tutor also states that the total number of...

Pls. find my ACCESS program as attached. Just click "PIP1 Student-Teacher Mapping" to start the mapping work. Normally, there should be 241 records in "tblST_Map_PIP" but 207 records. You may run "qryUpdate_Student_PIP_Map_Reset" and "qryUpdate_TAvail_PIP_Map_Reset" to clear the "mapped" field...

I've 4 tables, tbl1, tbl2, tbl3 and tbl4. fld1 of tbl1, fld2 of tbl2 contain values of primary key of tbl3. They are long integer type. I have written a vba to loop tbl2 within the loop of tbl1 to compare fld1 with fld2. If comparison is equal, a counter is incremented and some field values...

Hi, I've a query (qryPIP1_TSessionsCnt) to cnt the number of occurrences of tutors' availabilities for teaching. It works fine. "qryPIP1_TSessionsCnt" SELECT tblTAvail_PIP.TRef, Count(tblTAvail_PIP.Session) AS SessionCnt FROM tblTAvail_PIP WHERE (((tblTAvail_PIP.AcademicYr)=2016) AND...

There's no Microsoft Word 16.0 Object Library in the Reference list. Pls. view the attached screenshots. Can I download it from net?

My MS installed Office is the Office Suite. Pls. see the attached file. Thank you.

I still can't locate Microsoft Word 16.0 Object Library with my MS Office 2016. There's no such an entry in it. I read an article "A reference to "Microsoft Word 16.0 Object Library" could not be added" at...