How to count only one activity

[#1]

I have a database like this:

Name	Date	Equipment	Activity	Start Time.
WILMAR BERNAL	23/08/2012	BOGOTA 1	M.P	22:00
HELMAN MAHECHA	23/08/2012	BOGOTA 1	M.P	23:00
HELMAN MAHECHA	24/08/2012	BOGOTA 2	EMERGENCY	10:00
WILMAR BERNAL	25/08/2012	BOGOTA 2	EMERGENCY	10:30

Based on the table, i need to count the number of activities, but to do that is necesary compare diferent columns, for example if the EQUIPMENT column, the ACTIVITY column, and the DATE column are equal for diferent items from NAME column, only count 1 Activity on a Chart, for example in the table above, the count of M.P in BOGOTA1 at August 23th must be one.

How can i do that?

Sorry for my english.

[CELAMBARASAN · Accepted solution]

Hi,

Check with this

Count(Distinct Date&Equipment&Activity)

Celambarasan

[#3]

Thanks a lot, that was a very good solution.

Best Regards from Colombia.

[#4]

Thanks a lot, that was a very good solution.

Best Regards from Colombia.