?
Solved

Access Reports - Create Column Comparison

Posted on 2011-03-24
6
Medium Priority
?
548 Views
Last Modified: 2012-06-27
'm preparing a Profit and Loss in Access, and I have 2 questions.

#1 - Is there was any way to switch the detail section from being vertical to being horizontal?

For example:

Right now in Access reports it is always vertical

--------------------------------------------------Detail Section --------------------------------------------
                 Revenue            Expenses         Net Income
January    $5,000                $3,000               $2,000
February   $6,000               $8,000               $2,000
March
etc.


I want it to be horizontal:
--------------------------------------------------Detail Section --------------------------------------------
                January             February                 March            etc...
Revenue
Expenses
Net Income


Is this even possible?

#2 - Is there a way to create a field in the report that compares the values in that record to the value of the same field in the previous record?  To compare the revenue growth from one month to the next.

I'm trying to to make it look as much like a P&L from QuickBooks as possible.
0
Comment
Question by:rczuba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 58
ID: 35213269
<<#1 - Is there was any way to switch the detail section from being vertical to being horizontal?>>

  Not in the sense you think; rows always go down the page and columns across.  Reason being is that horizontal space is limited, where vertical is not.

  However you can get what your looking for by basing the report on a cross-tab query.

JimD.
0
 

Author Comment

by:rczuba
ID: 35216674
Well, I don't think that will work, because if the query is able to expand horizontally, but the report isn't, then it really is of little use to the user.  
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 1500 total points
ID: 35216774
QuickBooks uses Crystal Reports for its reporting.  Crystal has a cross tab report that can expand horizontally to add more columns as necessary.

Do you happen to have Crystal?

mlmcc
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:rczuba
ID: 35217690
I do not have Crystal Reports.  What would I need to download in order to get it?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35217824
It is a commercial product.  You would have to buy it.  

You can get it from
www.SAP.com

mlmcc
0
 

Author Closing Comment

by:rczuba
ID: 35244918
x
0

Featured Post

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question