Any ideas on how to make a count(*) (1 Viewer)

[HenryM]

Have been working on a report for a few days now.
It is sorted by a main option wich is in number form. Using Dlookup it will show the name of the option. (no problems here)
It will then show the three possible options after the main option and this is then listed. It then proforms a count(*) at the end of this to show the sub total of how many records are in the main option.
What we would like it to do is insteed of showing the three possible options in a list running down the page is to show the three options with a number next to them.
TO SIMPLIFY: Would like it to show the totals of the 3 possible options insteed of listing them down the page.
Any one have any ideas?/

 

[Fornatian]

Put an unbound control next to the control label and set its control source to a condtional sum:

=Sum(Iif(Me!MyOptionRecord = "Option1Name",1,0))

May need moving from the detail to the form header to work.