Dcount Or Dsum

[Beerman3436]

I have fields on a report the I need to Count the number of times a person use different things.

PC TV PHONE ETC.

I have a input form with a pull down menu to select one of the above.

Now on the report field.
I want to fills the 4 fields by sorting by SSN and TYPE.

So how do I write the code? I am trying this now:

=DCount("[FIELD]","("

","[FIELD]="TYPE") and ([SSN] = " & [SSN]")

Help please

 

[Rich]

I wouldn't use aggregate functions for this esp. if it's a large report. Assuming you group by the person just add text boxes to the group footer =Count[Field1] etc. If you use the wizard to build the report it will do most of the work for you.

 

[Beerman3436]

Well I want all the results to be on one line not multiple lines for each record. How can I do that?

 

[Rich]

Use the Report footer then =Count([Field1]) etc