Recent content by AlefAelol

Many thanks, I will try your method to see what the wrong is

No never for all fields

I have some functions, but they are all return numbers

This issue appears sometimes not all times, it happens when a user deletes date from the ScndCrseFrstAsses and ScndCrseScndAsses by the delete key

Some beautiful minds work like crystal ball with accurate 100% :). The calculated filed I use is =IIf([txtRes]=5 And [txtTotal2]<50,[ScndCrseFrstAsses]+[ScndCrseScndAsses],Null) Details; txtRes is also a calculated filed based on a function and this function returns only numbers...

I have a subform of some calculated fields that calculate date from other fields. I am getting "#Type!" error at the calculated fields. I did some searches and found that happens when trying to calculate different data types together, however, my fields to be calculated are all "NUMBER" data...

information in UNBOUND controls are not for further uses as I know. In my case, fields like average or ResFCourse later they would be used to filter the students. Example, if I want to find the top 3 students according to their averages, how could achieve this task if there is no students...

Can I DlookUP "ResFCourse" from "qryStudentsResults" into "qryStudentsMark" by "StudentRegID"?

For some reasons, I would keep the first part of your statement with no comment . Well, I am already using a form and subfrom, however, the subfrom is based on "TheResultedQuery" because all fields should be shown to the user. Again, based the subfrom on a non editable query would led to non...

Also, the field "SAFExam" would be filled by hand once "SAFirstAssest" get values

It would be hard to create/delete table each time the record is edited for thousand of records

In the "TheResultedQuery" there is a field named "SAFirstAssest". This field in calculated depending on the two joined queries. I can't find another way to find "SAFirstAssest" unless join the two queries. In the query mode or the form mode, the resulted query would be non editable

Thank you arnelgp for the replay, Unfortunately, not worked

Thank you Mike for the replay, sure ! Uploaded with regards

Hello everyone, I have a query "qryStudentMarks" which include students marks for the whole academic year, and a group-by query "StudentsResults" that hold some calculation fields such as student semester result (Pass and Fail) and averages. I want to combine the both quires but want the...