i have a CR that list the weekly payroll for people in my company.
it is a flat file like so
first name last name payment payment date
tom johns 5000K 1/20/2008
jack hamoke 4000K 1/20/2008
..........................
now that i have the data i need to show in the header of the report
something like this (i have no idea where or how do i put the sql that can do below) i just need the total
people how made $1000 to $2000 = 10
people how made $2001 to $5000 = 30
and so on
thanks guys