I heve five fields in my data base..... which are... most visited1,most visited2,mostvisited3,mostvisited4,mostvisited5..... and i have site's name in this fields..... in this same database table i am having Date and Store_Id.

 

i am creating report to display store information according to store_id... store_id i am taking from user parameter and same With Date range......

 

i have to show most visited 5 sites for given date range and Store_ID...... from thoes most visited1,2,3,4,5..... fields........

 

and i can not do this as count of site name....  bcoz the condition is.....

 

mostvisited1 is 5 point

mostvisited2 is 4 point

mostvisited3 is 3 point and so on

 

if from date range for 1st day if macy.com is thr at most visited1 and on second day its on 4 number thn 5+2=7..... like that i have to count for all days..... and highest 5 points will be the most visited sites... and i have to use that field in report.....

 

is any one is thr who can work on this problem?????

 

thanks