This query must be able to display data by the dates that the user selects meaning that the field names will change. Now I want to display this data graphically using a bar graph. But when I create the graph it runs fine until I change the dates of the query. Now I was wondering if there is a way to have the Report Wizard create the report on the fly using VBA? I remember reading something a few years ago about this but at the time I didn't need to use the function.