V
venkey_2010
Hi i having the huge number-of data's . In that i need to count the repeated
values in ms access using query. I tryed using "Group By" & "Count". When
run this query i only count the repeated values and give one some of amount .
i need to count if one number repeated 3 times it should count a 1times , a
2times, a 3times like this . we can use this in excel with help off count if
(eg: =countif(a2:a100,a2)).
but we cant do this ms access so please help me..... if any one know send
the solution to (e-mail address removed)
values in ms access using query. I tryed using "Group By" & "Count". When
run this query i only count the repeated values and give one some of amount .
i need to count if one number repeated 3 times it should count a 1times , a
2times, a 3times like this . we can use this in excel with help off count if
(eg: =countif(a2:a100,a2)).
but we cant do this ms access so please help me..... if any one know send
the solution to (e-mail address removed)