Histogram - Resources over time, Multiple queries into one report

[dargo72]

Good Morning,



I would like to have a report (bar chart) that shows the quantity of personnel present in each quarter (4Q 2011 - 4Q 2014). People are coming and going over time and I've designed the query to accuratley capture the quarterly reality.

Currently, I have 13 separate queries (one for each quarter between 4Q 2011 and 4Q 2014.

I would like to capture these counts and apply them to a report showing the resource realities by Quarter.

What are the steps necessay to pull this data from the inivdual queries and apply is seamlessly to a nice report?

Thank you,

[June7]

Sounds like might need a UNION query to get all 13 queries into one. Or maybe go back to the data source and see if one query can be structured to accomplish. Can't be sure without knowing more about your data. If you want to provide, follow instructions at bottom of my post.

[dargo72]

Thank you for the response.

Here is what I'm thinking.

1. Create a table with fields such as 4Q 2011, 1Q 2012...... 4Q 2014.
2. Create an append query with the dozen or so inividual queries created for each quarter over that time span.
3. When I run the query, have it update the fields on the table with the current data.
4. Create a bar chart report based on the table.

Thoughts?

[June7]

If you can build a query to update the table then a query should be usable as the graph data source. I would need a better understanding of your data structure.