Redundent data in Report!

[tsukeepr]

I am building a database that calculates totals on users in a system. I have a generic list of all possible users, and every month I get a list of each time a user went into the system and how long they stayed there.

My question is, I can't seem to get the reports to just show a user once, it lists the user over and over,(however many times it entered the system), this makes the report over 200 pages. Is there any way I can have a report that gives me one heading like branch and under it it lists each user only once with there total time given?

EX: branch 1
john doe 10 hrs
jane doe 4 hrs

Intstead of
Branch 1
john doe 4 hrs
john doe 4 hrs
john doe 1 hrs
jane doe 2hrs
jane doe 2hrs

 

[antomack]

Grouping by branch and then user should give you the results with one occurence of each user in each branch. If the report is giving you more than one line for each user then it implies that your grouping contains something other than Branch and User which causes the multiple occurences.

Best to do a query and group by Branch and then User and sum the hours. Then build your report on this query and put in any group headers, etc.. as you require.

 

[tsukeepr]

Thanks I will try that right away!