Graph help

[Benson112]

Hi there,

I need to create a graph containing monthly data for numbers of changes raised.

It needs to display the total amount of changes raised split into priority per month like this:

Do i need multiple queries for each month? How do I collate them all together to create the graph?

Thanks in advance

 

[Benson112]

http://i38.photobucket.com/albums/e111/Benson112/Changegraph.jpg

 

[Benson112]

Ive posted the link because the picture didnt seem to work

 

[Rabbie]

The link doesn't work for me.

Look up Union Query in access help

 

[Benson112]

Sorry typo, try the link again.

Cheers...

Phil