I have two calendar text boxes and the user is supposed to select a date range (for example 1/1/2009 - 5/30/2009).
The output I get from my code is this:
publisher DateSent projectmgmt_Rating
pub1 2/28//2009 5
pub1 2/28/2009 3
pub1 5/25/2009 1
pub2 3/15/2009
pub2 4/16/2009 na
pub3 3/31/2009 4
pub4 4/30/2009 4
pub4 1/30/2009 5
What I need to output is the average rating for each publisher. The output should look like this if the user selected the
date range 1/1/2009 - 5/30/2009
publisher Average Projectmgmt R ...
Go to the complete details ...