Hi..
I have a table in which there are fileds sample_ID,sorter and another table with field split and bigrare.


One sample has a sorter and a person can sort more than one sample.
I want to create a report such that the report shows how many samples a person has sortered and how much is the total count.
for example.
if the table has the follwing data
sample_ID sorter bigrare split
111 xyz 2 2
112 efg 5 3
121 xyz 2 4


Then I want the report to have the follwing infomation:
Sorter No. of Samples Toal Bigrare total Split
xyz 2(111 and 121) 4(2+2) 6(2+4)
efg 1(112) 5 3

I am not sure how can I do that...please help me.
If u have trouble undestanding the table and report format ..please see the file attached..

Regards
Rahul

Try this kb article
http://support.microsoft.com/default.aspx?scid=kb;en-us;141624