Search results

Kindly have a look at this database and look Students examination details. I want to undo changes saved.

I have a main form and a subform from 2 tables. How can i remove a field from sub form without deleting from a table?

Rank totals for subjects please. Thanks in advance

That was for subjects only. I need the totals for subjects

Hello everyone. I am trying to rank the Students based on the total marks of the subjects being entered. Kindly check attached database. Somebody to help me with a function or query to rank total marks of Students. Kindly check Student Examination Details (from subform). Thanks in advance. God bless

Genius as always.👏👏👏👏👏👏👏👏. God bless you so much. Thanks, thanks, thanks and thanks. Be blessed.

Hello everyone. Kindly look at this updated database. Kindly anybody to assist me with the query to give out rank as indicated in the Student Examination Details(derived from sub form). As you enter marks the query or function to update the position as per subjects. Check the database. Thanks in...

@arnelgp is genius. He has helped so many people in matters computer. He is blessed with knowledge. God will bless him abundantly.

Thanks. Is there a way to sort subjectID automatically. It is working but I have to sort subjectID manually. I would like the user of database not to sort manually. I wish there was something like vba code, function or query. I appreciate what you are doing. Kudos

Thanks. But it would be great if there was a query or function which should sort it automatically.

Hello everyone. I am humbly and kindly requesting for somebody to assist me rank the subjects in the description in the attached database. The query or function should rank subjects automatically as the mark is being entered for students. E.g student A ENGLISH 60, STUDENT B ENGLISH 70, Student C...

It works. Thanks. Be blessed.

Genius. Thanks. Be blessed.

Edited Edited This works. Unfortunately, I am defeated on where to put separator. =IIF(Format(Now(), "mmmm")="JANUARY", "TERM ONE",""),=IIF(Format(Now(), "mmmm")="FEBRUARY", "TERM ONE",""),=IIF(Format(Now(), "mmmm")="MARCH", "TERM ONE",""),=IIF(Format(Now(), "mmmm")="APRIL", "TERM...

This works. Unfortunately, I am defeated on where to put separator. =IIF(Format(Now(), "mmmm")="JANUARY", "TERM ONE",""),=IIF(Format(Now(), "mmmm")="FEBRUARY", "TERM ONE",""),=IIF(Format(Now(), "mmmm")="MARCH", "TERM ONE",""),=IIF(Format(Now(), "mmmm")="APRIL", "TERM ONE",""),=IIF(Format(Now()...

This is not what I meant but thanks for your query. What I mean is the term has 4 months that is: JANUARY, FEBRUARY, MARCH, APRIL- TERM ONE MAY, JUNE JULY, AUGUST- TERM TWO SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER- TERM THREE

Date. term 1/1/2022. Term 1 1/2/2022 Term 1 1/3/2022 term 1 1/4/2022. Term 1 1/5/2022. Term 2 1/6/2022. Term 2 1/7/2022. Term 2 1/8/2011. Term 2 1/9/2022. Term 3 1/10/2022. Term 3 1/11/2022...

Demo please

Hi everyone. I am requesting for somebody to help me come up with a query or a function so that if for example you enter today's date 6/10/2021 it brings TERM TWO. I tried =IIF(Format(Now(), "mmmm")=OCTOBER, "TERM TWO" But I get an error wrong number of arguments. Please help me