297406 Modify SQL for date & percents

I have an existing CF page that outputs an Access Crosstab query to an excel spreadsheet. I need to add a form that allows users to choose a date range for the query. In addition I need to create an additional page (just like the output of the exisitng crosstab query page) which shows the results as a percentage of each users total. I can send the Access db and working (and non-working) CF pages.