Record Counts

[Frazer]

Hi,

I'm trying to work out a way to display a list of how times a certain value is in a field. In essence I want to be able to display the data in a layout as follows:

response A (no. times)

response B (no. times)

response C (no. times)

response D (no. times)

I'm looking for a way to calculate how many "A"s appear in field "response".

Any suggestions?

Thanks

[dspires]

You'll need a field for each response set to 1 or "" (empty) as a result of a calulation, for instance resultA = if(response="A",1,""). Then all you need is a summary field for each option, set to either count or total.

[Vaughan]

Or use the Count() function. The suggestion to use a summary layout is spot on.