A
an
I hava a form with textboxes:
txtNInquirity
txtNDependant
txtTotalMembers
txtNDifference
Where field values are for example:
NInquirity = 1
NDependant = 11, 12, 13 (= 3 dependants with the same NInquirity = 1)
TotalMembers = 7
NDifference = 4
Or
NInquirity = 2
NDependant = 21, 22, 23, 24 (= 4 dependants with the same NInquirity = 2)
TotalMembers = 9
txtNDifference = 5
Type in txtNDifference:
=[txtTotalMembers]-Count([txtNInquirity] Like [NInquirity]=[txtNInquirity])
where NInquirity is the field name.
I would like your help, please.
Thanks in advance.
an
txtNInquirity
txtNDependant
txtTotalMembers
txtNDifference
Where field values are for example:
NInquirity = 1
NDependant = 11, 12, 13 (= 3 dependants with the same NInquirity = 1)
TotalMembers = 7
NDifference = 4
Or
NInquirity = 2
NDependant = 21, 22, 23, 24 (= 4 dependants with the same NInquirity = 2)
TotalMembers = 9
txtNDifference = 5
Type in txtNDifference:
=[txtTotalMembers]-Count([txtNInquirity] Like [NInquirity]=[txtNInquirity])
where NInquirity is the field name.
I would like your help, please.
Thanks in advance.
an