Recent content by mercystone

It is so disheartening to go on everywhere discouraging people who want to be assisted as if you know everything. You should learn to shut your mouth. @arnelgp is very experienced and he has helped so many people. Learning is a process for some people especially who are novices to ms access...

Thanks so much

Kindly have a look at the form frmStudents 1. Print ALL SUBJECTS 2. Print 7 SUBJECTS. Please I am requesting you. Please.

@arnelgp here it is. Look at frmStudents and assist me come up with frmcriteria to do the following:- 1. Print all subjects 2. Print 7 SUBJECTS.(7 best perfomed Subjects even if there are ties to print only 7 e.g:- 1. Subject 1 -80 2. Subject 2 -80 3. Subject 3-80 4. Subject 4-80 5. Subject 5-80...

@arnelgp it is not working. I have tried the whole day. Thanks but if there is a function i have a feeling it will work. Thanks for your help

@arnelgp thanks.

It works. However, it selects more than 7 Subjects in case Subjects tie. In case of a tie it should pick the 7 top tied Subjects.

Thanks @arnelgp

@arnelgp I tried using this but it has given me headache:- Please kindly use the attached database and help me come up with a query or function to print only 7 best perfomed Subjects out of all subjects done Kindly. I really don't know how to apply what you said here because I was also...

Please @arnelgp

@arnelgp kindly assist me with the function or query to print only 7 SUBJECTS OUT OF STUDENTS done. Please i am defeated. Only 7 SUBJECTS to be graded

Thanks so much

Kindly help me rank Subjects according to:- YEARS TERM GRADEDESC STREAM EXAMINATION TYPE Thanks in advance.

@Gasman and @Cronk looks like you hate women. You should be banned from this forum forever. Your time will come

No wonder you are enthusiastic amateur. You ought to learn to respect people. But then again I didn't address you.