View Full Version : Counting and merging sums of running number in report


syunichi
11-28-2007, 05:42 AM
Ok, I'm stuck with this. I thought I had it right by counting total data's with Count(*), instead I didnt realised there is a redundant data should be counted as 1 when it gives 2 or more information.

http://www.geocities.com/syunichi2000/abc.jpg

What I am trying to do is delete all the running numbers made with =1 txt box value and sums all in groups and overalls of project code. What I did was counting numbers of existing Employee_No in the report. And I want to bundle 2 details for an Employee_No as 1 data and in the end bundle 2 Employee_No from different Project as 1 data. I tried DCount and I failed. Any suggestion?