General Report Question

[wop0703]

Can I create a chart report using multiple queries instead of just one?

 

[TessB]

It depends. What exactly are you trying to accomplish?
More details please.

 

[wop0703]

I have four different queries, all have hours worked from a specific time period. I want to put those four queries into a single bar chart. Is this possible?

 

[TessB]

Yes, it is possible.

If all queries have the same field names (or if you can make them the same) a Union Query will work well.

Unfortunately, you cannot write Union Queries automatically. They have to be typed by hand. However, you can copy the SQL from each query and paste it into your Union Query easily.

But remember, individually, the queries must all look exactly the same (but pull different data) in order for that to work.

If you need more help, post your queries and I'll show you how to put them together.

Tess