What function to use this process

[azhar2006]

Hi all


I have a model 4 text box based on the fields in table I (ِِA) and (B) and third (C) and (D).
And also there is an unstructured text box is the fifth name (H).
What I want is how I show my total text boxes where values only in informal text box (H)

A	B	C	D	H
55	21		20	3
67				1
68	44	50	22	4
	11		10	2

I tried using the function DCount But to no avail

[June7]

Aggregate functions are for evaluating column of data. If you want to count columns that have data in each record:

=IIf(IsNull(A),0,1) + IIf(IsNull(B),0,1) + IIf(IsNull(C),0,1) + IIf(IsNull(D),0,1)

[azhar2006]

Thank yougorgeous,John