• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 552
  • Last Modified:

Access Reports - Create Column Comparison

'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
rczuba
Asked:
rczuba
  • 3
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<#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
 
rczubaAuthor Commented:
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
 
mlmccCommented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
rczubaAuthor Commented:
I do not have Crystal Reports.  What would I need to download in order to get it?
0
 
mlmccCommented:
It is a commercial product.  You would have to buy it.  

You can get it from
www.SAP.com

mlmcc
0
 
rczubaAuthor Commented:
x
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now