i want to subject count but formula is not working plz help me to solve the issue.

moin555

New member
Local time
Today, 14:29
Joined
Feb 6, 2025
Messages
19
1744113233162.png
 

Attachments

The DLookup expression includes the name of a non-existent query.

=DLookUp("[CountOfSubjectEnrolled_Value]","qry_SubjectCountPreStudent","[registrationq] = " & Nz([registrationq],0))

1744114768022.png
 
the Registration form will use query registrationq.
while there is another similar query, registrationqReadOnly, that has all the calculation.
but you cannot Add/Edit records to this query since it is readonly.
you use it for Making report or to a form that is for Viewing info only.
the Total Fee on the form is calculated as Subject Fee x Subject Count.
 

Attachments

the Registration form will use query registrationq.
while there is another similar query, registrationqReadOnly, that has all the calculation.
but you cannot Add/Edit records to this query since it is readonly.
you use it for Making report or to a form that is for Viewing info only.
the Total Fee on the form is calculated as Subject Fee x Subject Count.
i understand but sir total amount and monthly fess is also update for against student registration. and then also use for fee challan ?
 

Users who are viewing this thread

Back
Top Bottom