This is a question in 2 parts:
First off, since i'm new, I'll introduce myself. I'm a self taugh Access database designer. Lets just say that the first stuff I started off with was very embarrasing
But i have alot of programming background. I have been with access a while now and now understand SQL decently and actually use it pretty intensely, but definitely not as well as I could.
I currently am automating a report process. I got it done, it works great.
But the amount of data that I'm working with is insane. Luckily, it is transient and needs only to be analyzed daily before its is disposed of and stored permanently as zipped delimited files.
I needed to create a graph of 19 trains moving on a system with 8 station stops. Each stop is automatically recorded, and we want the graph to show trains stopping at each stop over 3 8 hour periods for each day: 12 to 8, 8 to 4, 4 to 11:59:59.
The queries were easy. Created a crosstab table to show train values by time (row) and stop (column).
But I wanted the query to show with time on the Y axis and stops on the X axis so that I could show the report in landscape while still printing it out (to the computer atleast) in portrait.
Reason: Several other parts of the report need to be in portrait.
I can't make time the column, Access reports error as too many entries to display as a column.
I don't know, atm, of a way to make a SINGLE report show both landscape and portrait at the same time.
This is not that important, but if anyone has ideas, that would be sweet.
The BIG problem was this.
The graph ( I need a string graph with points) only shows the points, it won't show the "strings" ie lines, connecting each point. The reason is because there are just too many records.
I culled the data down using a vba loop to only show 1 stop per minute. (BTW, is there a way to do this using only SQL?) I now show all record points, but still do not show the lines between points. Some of the lines show up, but the more data points on the graph there are, the less the lines show up, till only one or two show.
This is an Access limitation that I'm unsure of how to get around. This really shouldn't be an issue though, because Excel handles the graph just fine EVEN BEFORE the culling of the data down to access acceptable limits. And it shows the lines between each record as well.
Does anyone know of a resolution for this?
Kelemit
First off, since i'm new, I'll introduce myself. I'm a self taugh Access database designer. Lets just say that the first stuff I started off with was very embarrasing
But i have alot of programming background. I have been with access a while now and now understand SQL decently and actually use it pretty intensely, but definitely not as well as I could.
I currently am automating a report process. I got it done, it works great.
But the amount of data that I'm working with is insane. Luckily, it is transient and needs only to be analyzed daily before its is disposed of and stored permanently as zipped delimited files.
I needed to create a graph of 19 trains moving on a system with 8 station stops. Each stop is automatically recorded, and we want the graph to show trains stopping at each stop over 3 8 hour periods for each day: 12 to 8, 8 to 4, 4 to 11:59:59.
The queries were easy. Created a crosstab table to show train values by time (row) and stop (column).
But I wanted the query to show with time on the Y axis and stops on the X axis so that I could show the report in landscape while still printing it out (to the computer atleast) in portrait.
Reason: Several other parts of the report need to be in portrait.
I can't make time the column, Access reports error as too many entries to display as a column.
I don't know, atm, of a way to make a SINGLE report show both landscape and portrait at the same time.
This is not that important, but if anyone has ideas, that would be sweet.
The BIG problem was this.
The graph ( I need a string graph with points) only shows the points, it won't show the "strings" ie lines, connecting each point. The reason is because there are just too many records.
I culled the data down using a vba loop to only show 1 stop per minute. (BTW, is there a way to do this using only SQL?) I now show all record points, but still do not show the lines between points. Some of the lines show up, but the more data points on the graph there are, the less the lines show up, till only one or two show.
This is an Access limitation that I'm unsure of how to get around. This really shouldn't be an issue though, because Excel handles the graph just fine EVEN BEFORE the culling of the data down to access acceptable limits. And it shows the lines between each record as well.
Does anyone know of a resolution for this?
Kelemit
Last edited:
