Count in form

[LEEWEI]

Hi,
I've 2 questions.
1) I've a field call ProdType and I would like to do a count on the different Prodtype and place the total number onto another unbound field.

2) I've another field which consist of the days different. How can I count on the days which are greater that 10.

Please help. Thanks!

 

[ericgeil]

Make sure you have a Form Footer visible (In Access 2000 it's View -> Form Header/Footer)

In the footer place a text box and place this in the Control Source Property:

=Count([Prodtype])

 

[dennyryan]

In response to Question#2, I would create a field in your query that would derive this count:
GreaterThan10:iif([Diff] > 10,1,0)

Add this field to your form, probably with the Visible property set to No,
in the footer section add a text box and set the value to =sum([GreaterThan10])