I have a temporary table named crsmatch with 4 fields named:

crsmatch.key1.......crsmatch.key4.

crsmatch.key1 - Season
crsmatch.key2 - Department
crsmatch.key3 - Number
crsmatch.type - Type

The type can be of Sample or Technical

I have 2 additional fields named countsamp and counttech ehich count the number of records that are either Sample or Technical. A typical results would be

KEY1 KEY2 KEY3 KEY4 COUNTSAMP COUNTTECH
AW2002 T59 JKT001 SAMPLE 1 0
AW2002 T59 JKT001 TECHNICAL 0 1
AW2003 T57 JKT002 SAMPLE 1 0
AW2003 T57 JKT003 TECHNICAL 0 1

And so on

I have a combo field on my form listing the seasons. When I select the Season in the combo box I want to display the relevant records in a grid.
For example if I chose AW2003 I would get:


AW2003 T57 JKT002 SAMPLE 1 0
AW2003 T57 JKT003 TECHNICAL 0 1

In addition I would like to total the 2 count columns so it would say:

Number of Samples - 1
Number of Technicals - 1

Can anybody put me in the right direction?

Thankyou