Showing all months in Graph

[lukepollard]

Hi,
I am stuck on creating a graph in MS access and was wandering if anyone can shed some light on it. I have a query that counts all the bookings in each month, this is then put into a line graph that shows the amount of bookings (y axis) and the month (x axis)

However, the graph isn't displaying the months that have no bookings in along the x axis, is there a way to set up the graph to show all the months, even if there is no booking in that month? i.e. so the line would go to '0' during that month.

Many Thanks

Luke

 

[ted.martin]

You are going to have to find a way to 'force' by default each month's name so that your counting query can attribute the value zero to that month. A table with 12 entries would be a start plus a further field called total. Then maybe using an update query, apply the total to the tables total field for the appropriate month. Your graph would then source its data from this new table.

note: as you haven't mention 'Year' I assume that is not relevant - bearing in mind that assumption can be dangerous as assume makes is an ass of u and me!!!

 

[lukepollard]

reply

Hi Ted,
Thanks for your reply. It would just need to be for a one year period, from the date it is performed.

The dates are stored in a table titled "tblbooking" in a date field as a short date. Will this affect your advice? The months are not actually defined in any other field, just the short date i.e. 19/02/2008