Help with CrossTab Query (1 Viewer)

[joeserrone]

Hello Everyone,
I'm attaching a sample of the database with my post. I have a query called Evaluation_Qry based on the result of the other queries in this database. As you can see I am pulling data using a site criteria and a data range criteria. I'm trying to take the Evlauation_Qry and create a crosstab (or any other way you guys thing might work) or a report that will show the data in the format I have attached on my Excel Spreadsheet...

 

[ajetrumpet]

Joe,

You have very few objects in your database, and your crosstab would be the 4th stacked query in a this series. I would recommend normalizing your data, or at least reorganizing it, so you can get this done in less moves.