Count records

[ootkhopdi]

Sir i m a begginer for access
i want to count records in progressive access table .in simutanasly column
like excel "countif" function if Attached File
EX.

Column A Column B
A Count (A) =1
A Count(A)= 2
A Count (A)=3
B Count (B) =1
B Count (B) =2
A Count (A)= 4
pls help me

Thanks in advance

 

[namliam]

You want to make a query like:
Select YourCOlumn, Count(YourColumn)
from Yourtable
Group by YourColum

To make this query in the designer, make a new query and add your table. Now find the Sigma sign (Big M on its side) and click it ... This creates an extra line in your query that defaults to Group by.
Now add your column (two times) and change one to "Count", run your query and be happy

 

[ootkhopdi]

Dear Sir, Thanks
But it return only block count and only "1"
while i want result as count of a particular record till that row
like
Row NO. Column 1 Column 2
(records) Count of records
1 Master 1
2 Master 2
3 Raju 1
4 Master 3
5 Raju 2


Thanks once again


Ootkhopdi

 

[namliam]

unfortunately something like that is not very doable in Access since there is no such thing as a running count not even something like a rownumber

If you have a Primary key you can sort by you can do the running count perhaps with a subquery.... but no really simple easy solution