Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Check with this
Count(Distinct Date&Equipment&Activity)
Celambarasan
Hi,
Check with this
Count(Distinct Date&Equipment&Activity)
Celambarasan
Thanks a lot, that was a very good solution.
Best Regards from Colombia.
Thanks a lot, that was a very good solution.
Best Regards from Colombia.