Report Query into a Table

[opostal]

I originally posted this in the incorrect forum so thought I should move this to the report forum.

I have a query that gives me data which includes dates. The data is captured for a week long period and subdivided by a project name. The result I would like to have in the end is a report which vertically lists a project name and then horizontally lists Monday, Tuesday, Wednesday, Thursday, Friday and Saturday. I would like the report to state that "X" amount of hours were applied to project "1" on Monday, and "Y" amount of hours on Tuesday etc etc.

My query is created to provide that data but I am unsure of how to get that into a readable table format on a report form, preferably in a grid format if possible with weekdays horizontally and projects vertically.

Thank you for any assistance in advance.

 

[opostal]

As an update I am doing this with a crosstab query but my current problem is that I get the error of:

"Invalid bracketing of name "[Between [Forms]![Start Date]![txtDate] And DateAdd("d",7,[Forms]![Start Date]![txtDate])]".

I have tried multiple variations of this with the brackets and the parentheses on the original query and listing them under the parameters section too.

Thanks again.