Total count

[Frank O'Neil via AccessMonster.com]

Again, Form-1 contains the fieldname from Tabl-1 example of fieldnames in
-Tabl1
-custname
-address
-addres1
-state,Zip
-catergory
Table-1 information is used to create form-1,
Category is defined as a text. So the G or B or F is store in the database
under catergory.
however, in form-1 under the catergory,is a dropdown box(combobox) with
different option of

G-Good
B-Bad
F-Fair

The selection of catergory from form-1 populate form-2 as shown below.

Form-2 - contains the result or the summary of the selection from the
catergory combobox. The user want to know the total account of G,B,F.
Form-2. The option can only be done per record. example display heading
Display headings in this format
Good Bad Fair
G
F
G
B
Total 2 1 1
Question-how to calculate the total in form-2. Let me know what you don't
understand.

 

[Douglas J Steele]

A Crosstab query should be able to give you that.