Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-11-2019, 01:15 PM   #1
dynamictiger
Newly Registered User
 
Join Date: Feb 2002
Location: Perth
Posts: 260
Thanks: 11
Thanked 1 Time in 1 Post
dynamictiger
Need Help With Layout and Getting Data on One Document

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?

__________________
Perth, the most isolated capital in the world
dynamictiger is offline   Reply With Quote
Old 06-11-2019, 01:17 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,063
Thanks: 36
Thanked 730 Times in 713 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Need Help With Layout and Getting Data on One Document

Hi. Just a though but have you considered using charts or bar graphs?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
dynamictiger (06-14-2019)
Old 06-11-2019, 01:22 PM   #3
June7
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Posts: 1,959
Thanks: 0
Thanked 463 Times in 459 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Need Help With Layout and Getting Data on One Document

Graphs can be very helpful in analyzing data. But if you also want to provide tabular data, review http://allenbrowne.com/ser-67.html

Building stable report based on CROSSTAB is tricky but can be done.

__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
dynamictiger (06-14-2019)
Old 06-14-2019, 03:22 PM   #4
dynamictiger
Newly Registered User
 
Join Date: Feb 2002
Location: Perth
Posts: 260
Thanks: 11
Thanked 1 Time in 1 Post
dynamictiger
Re: Need Help With Layout and Getting Data on One Document

Thanks for the suggestions
__________________
Perth, the most isolated capital in the world
dynamictiger is offline   Reply With Quote
Old 06-14-2019, 03:52 PM   #5
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,063
Thanks: 36
Thanked 730 Times in 713 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Need Help With Layout and Getting Data on One Document

Quote:
Originally Posted by dynamictiger View Post
Thanks for the suggestions
Good luck and please let us know how it goes.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 06-14-2019, 04:56 PM   #6
Micron
Newly Registered User
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 731
Thanks: 3
Thanked 148 Times in 142 Posts
Micron will become famous soon enough Micron will become famous soon enough
Re: Need Help With Layout and Getting Data on One Document

Quote:
Perth, the most isolated capital in the world
Ended my Australian/New Zealand cruise in Perth (best vacation EVER). Regrettably was only able to spend 1 day there but got to see some interesting sites nonetheless.
__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
Old 06-14-2019, 08:30 PM   #7
dynamictiger
Newly Registered User
 
Join Date: Feb 2002
Location: Perth
Posts: 260
Thanks: 11
Thanked 1 Time in 1 Post
dynamictiger
Re: Need Help With Layout and Getting Data on One Document

Its not bad place to live. I migrated here from Auckland in 1994. It was as though I stepped on the Tardis and flew back 10 years. The Perth I arrived in was almost quaint with service stations not open Sundays, shops only trading Monday to Friday and so on. I was stunned.

__________________
Perth, the most isolated capital in the world
dynamictiger is offline   Reply With Quote
Old 06-14-2019, 08:33 PM   #8
dynamictiger
Newly Registered User
 
Join Date: Feb 2002
Location: Perth
Posts: 260
Thanks: 11
Thanked 1 Time in 1 Post
dynamictiger
Re: Need Help With Layout and Getting Data on One Document

Quote:
Originally Posted by theDBguy View Post
Good luck and please let us know how it goes.
I found an online example I think will work nicely. More or less I am planning to show columns of numbers:

Pool Average This Month Last Month

Consumption levels are what we are looking at. I considered charts but thought I would need a lot and after a while they would become meaningless. Based on the example I saw I am thinking I use conditional formatting and highlight in a traffic light system according to variations in consumption. I think this achieves the objective and gives a clear simple report with minimal pages.

Thanks for the suggestions though if it wasn't for them I wouldn't have got to where I am.
__________________
Perth, the most isolated capital in the world
dynamictiger is offline   Reply With Quote
Old 06-14-2019, 09:53 PM   #9
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 9,447
Thanks: 106
Thanked 2,535 Times in 2,328 Posts
isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all
Re: Need Help With Layout and Getting Data on One Document

Hi
In case it helps, have a look at the screenshots on this page http://www.mendipdatasystems.co.uk/s...ser/4584605482.
These show some of the charts and also the use of traffic light formatting in various forms and reports with one of my apps. There are other free examples on the site as well

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Layout of Data AccessQuestions Queries 1 03-04-2014 01:34 PM
How to show the data in such layout accesser2003 General 3 07-09-2007 03:02 PM
Query to change Data layout waffleguy Queries 3 02-26-2007 02:44 PM
Help with layout of data on report Whisper Tech Reports 2 08-30-2004 05:54 AM
change Data layout Chimp8471 General 6 07-06-2004 01:22 PM




All times are GMT -8. The time now is 05:15 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World