Search results

Hello everyone. Kindly look at this attached database. I am trying to create Students fees payments database. I am defeated on how to have a report for accumulation of all payments in a term in a year for a student in a a class and stream so that each term when a school closes, the Student...

Hello everyone. This forum has really helped me. I really appreciate. Kindly look at the attached database. I am trying to filter records by form. Look at the form "frmStudents" and form "print Report forms" When you filter from drop-down for example Year- 2020 Class- form1 Stream-north Term-...

I have database of 50 Students. Students can select and do subjects which they wish. I have 5 subjects namely SUBJECT A, SUBJECT B, SUBJECT C, SUBJECT D, SUBJECT E. I know the easiest way of finding class mean is =Avg([Marks]). However, I want add mean of subjects done, add the mean and divide...

How are you doing everyone? I have a question? How do you filter a report from a tables which the user entered the fields manually? For example: Name. City. Age John brown. New York. 35 John brown. Oxford. 40 In this case john brown is from usa...

I have two tables. 1. Table for countries 2. Table for cities Out of this the main form is from table for countries and subform for table for cities. In the table for countries, the counties have been entered 1. USA 2. CANADA 3. ENGLAND. In the table for cities the user of database enters the...

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?

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

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...

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

Hi everyone. Kindly check the attached database and specifically look at the form. I really need help to find a code or a function to generate records of students doing a particular subject. E g if i select ENG to display students doing ENG, if i select BIO to show students doing BIO only and so...

Is there any vba code or a function which will instruct database user msgbox "SORRY YOU CANNOT USE THIS NUMBER BECAUSE IT IS BEING USED BY AND SHOW THE SAVED USER" Thanks.

Hi. Have a look at the attached database. Check on rptStudentsGrades. Kindly assist me to change it(rptStudentsGrades) to column.(spreadsheet) Please the user to enter marks and able to see reports horizontally not vertically. Thanks.

Pleasure to join