bakerratface
New member
- Local time
- Today, 13:52
- Joined
- Dec 29, 2007
- Messages
- 9
Hello,
I am trying to create a graph in access that will plot time on the X axis and a cumulative total on the y asses.
I (with the help of this forum) have managed to get a Dsum function to work in the query that I want to graph. I have also managed to get a function that converts time into decimal figers (e.g. if the time is 11:30AM then this becomes 11.5 – I have managed this by multiplying the time filed by 24)
For some reason when I try and graph the dsum function access won’t let me change the count option that it assigned to the chart on the y assess it just comes up with something like you cannot change the properties of a text fields…
Can anyone offer any assistance?
Thanks,
Alexander
I am trying to create a graph in access that will plot time on the X axis and a cumulative total on the y asses.
I (with the help of this forum) have managed to get a Dsum function to work in the query that I want to graph. I have also managed to get a function that converts time into decimal figers (e.g. if the time is 11:30AM then this becomes 11.5 – I have managed this by multiplying the time filed by 24)
For some reason when I try and graph the dsum function access won’t let me change the count option that it assigned to the chart on the y assess it just comes up with something like you cannot change the properties of a text fields…
Can anyone offer any assistance?
Thanks,
Alexander
