dynamictiger
Registered User.
- Local time
- Today, 22:31
- Joined
- Feb 3, 2002
- Messages
- 270
Every month I send a report to my customer showing chemical consumption. This has been a manual input in excel which is a bit of double entry as the data is actually in Access. I haven't been looking at this till now as it was on the old server and too hard etc in 2003 to do as much as I can now.
However now I have it in Access I can do cross tab to give a better looking output and in 2016 I can export this easily to various formats this is good enough for now. However …
I can now do the next level of data crunching and get comparative month on month consumption and averages and so on. Great. But how do I lay this out to be easily understood, transparent and as the data is all in cross tabs into a report? I have never put a cross tab query into a report either, so probably need some pointers here. But its really the layout so it isn't a bunch of numbers that become meaningless as too hard to read?
However now I have it in Access I can do cross tab to give a better looking output and in 2016 I can export this easily to various formats this is good enough for now. However …
I can now do the next level of data crunching and get comparative month on month consumption and averages and so on. Great. But how do I lay this out to be easily understood, transparent and as the data is all in cross tabs into a report? I have never put a cross tab query into a report either, so probably need some pointers here. But its really the layout so it isn't a bunch of numbers that become meaningless as too hard to read?