How to Use Dcount in Form

[alhareri]

hi


Can you help me to count how many Excuse in field and notExcuse in same field in the form for one employee?

thanks
see attachment

[June7]

=Sum(IIf([Excuse]="Excuse", 1, 0))

=Sum(IIf([Excuse]="NotExcuse", 1, 0))

If you want to show count for one employee then filter the form to show only that employee records. If you want individual count for each employee then Sum calc in footer would require textboxes for each employee. How many employees?

=Sum(IIf([EmployeeID="1401" AND [Excuse]="Excuse", 1, 0))

A domain aggregate (DCount, DSum) could be rather complicated.

Really should build a report.

[alhareri]

thanks a lot

[June7]

Issue resolved?