Report with side by side view by Day

[joeserrone]

I'm attaching to this post a sample of my database. I have a Query that obtains data based on a date range and other filters from a form. The Query has everything I need but I'm trying to display this data in a way it can be easily compared from day to day. What I would like to do is have a side by side for each day the Site, Task Description and related Volume. The report I can generate only can create a running report that shows the information by day but one under each other instead of side by side. Is there a way to put the dates side by side so that someone can more easily compare volumes day by day. I was thinking of a Cross tab query but I can't get it to work by using the various data filters I'm using from the form

 

[lark_tilly]

Take a look at the attached. I added a crosstab query which uses your query as it's data source. Actually I made a copy of your query and put in values because your form wasn't working right and your query didn't work as a result.
I believe the crosstab will do what you're asking.