Query Question - Combine records with same policy number

Query Question - Combine records with same policy number

am 08.02.2006 20:02:26 von BerkshireGuy

I need help with creating a totals query. My data looks like this (I
will only include 2 fields)


Policy Number App Status
-------------------------------------------
Z9999999 RECEIVED
Z9999999 DECLINED
Z9999991 RECEIVED
Z9999991 DECLINED
Z9999991 REOPENED
Z9999992 RECEIVED
Z9999992 DECLINED

Each row is a record here.

I want a count of policies that went DECLINED but only if they havent
been reopened.

So in the above example, I should have 2 declines since there was 3 and
one was reopened.

TIA
-B