Calculating total in a form

  • Thread starter Thread starter Frank O'Neil via AccessMonster.com
  • Start date Start date
F

Frank O'Neil via AccessMonster.com

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.
 
Hi,


You can use a Crosstab query to COUNT then number of G, B or F, per
category. Use that query to build your form.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top