Query Question - Combine records with same policy number
am 08.02.2006 20:02:26 von BerkshireGuyI 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