Count function

  • Thread starter Thread starter Norman Belanger
  • Start date Start date
N

Norman Belanger

I have a table that holds service call records. These service call can be
repeated in the table as long as the call holds an incomplete status of "I"
and when complete, a status of "C". The call sequence makes each record
unit. I'm trying to obtain a call count based on the "Service Call" field
without concerning myself with the "Call Sequence" and "Call Status" fields.
If I group the "Service Call" field and get a count of that field it, it
provides me with the record count of each. Although I need the call
sequence and call status for other results in the query, how do I get a
count on distinct Service Calls?

In my example below, I want my result to show a count of 3 calls.

Table1



Service Call Call Sequence Open Date Call Status
123456 1000 02/01/04 I
123456 1001 02/01/04 I
123456 1002 02/01/04 C

234567 2000 02/01/04 I
234567 2001 02/01/04 C

345678 3000 02/01/04 I
345678 3001 02/01/04 I

Thanking you in advance,

Norm
 
Norman


You have to take the fields out from the query that effectively ungroup the
records. Ie Call Sequence.
Can't have your cake and eat it too...

Try seeing if you can add a field with a 1 in it only to the start of the
sequence and them sum it maybe

Sean
 
Back
Top