Tammy...it will be easier to help you if you can please provide some scripts that create a table with suitable sample insert data scripts that describe you problem....along with the expected results based on your sample data......can you do this?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day