Counting formula for lists

[kolcun]

my data looks like this

LastName, FirstName, carID
...

I want to provide a count of the number of employees we have, but since some have the first same name, and some have the same last name, I can't just disctint count on either of those fields.

How can I execute the count only whe either field changes?

thanks a lot.

 

[rci]

Hi kolcun,

Is this an employee table? If not, what in the table identifies them as an employee?
Is carID an employee id?

If it is an employee table, can an employee have more
than one record in it?

Basically, to count the employees, you have to have
something that uniquely identifies each employee. If
you don't have that, you can't count them.

kidder

 

[dgillz]

Just do a regular count instead of a distinct count, if yu have 5 Jims at in oyur database all 5 of them will be counted. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[kolcun]

my fault.. I didn't explain my data enough..

ex.

Mike, Kolcun, 111
Mike, Kolcun, 222
Mike, Kolcun, 333
Some, Guy, 111
Some, Girl, 333
Some, Girl, 444

is the data in the table, (its not an employee table, and the number refers to the car that the user is authorized to drive) there is no real unique way to identify the users in that sense. I guess I could just do a count on the number of rows int the employee table.

 

[dgillz]

Unless you have 2 employees with the same first AND last names, create a formula field to concatenate the 2 names, then do a distinct count on the formula field. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com