vertical reports - Microsoft Access / VBA

KitesLive

Is there a way to make a report that works like an excel spreadsheet?
I want to record a set of values related to sales data every day and
then see it in a report with Mon-Sun at the top of the columns and the
sales depts and info down the left labeling each row of data. See the
simplified example below.

Mon Tue Wed
Thur Fri Sat Sun Weekly Total
Food Sales
Bar Sales
Total Sales

Cash Deposit
Discover
Visa
Amex

Voids
House Charges

Nov 6 '07 #1

Subscribe Post Reply

2142

Tom van Stiphout

On Tue, 06 Nov 2007 03:35:15 -0000, KitesLive <ki******@gmail.com>
wrote:

Check out "crosstab queries". There also is a query wizard to create
them.

-Tom.

>Is there a way to make a report that works like an excel spreadsheet?
I want to record a set of values related to sales data every day and
then see it in a report with Mon-Sun at the top of the columns and the
sales depts and info down the left labeling each row of data. See the
simplified example below.

Mon Tue Wed
Thur Fri Sat Sun Weekly Total
Food Sales
Bar Sales
Total Sales

Cash Deposit
Discover
Visa
Amex

Voids
House Charges

Nov 6 '07 #2

sirdaveo

On Nov 5, 9:35 pm, KitesLive <kites...@gmail.comwrote:

Is there a way to make a report that works like an excel spreadsheet?
I want to record a set of values related to sales data every day and
then see it in a report with Mon-Sun at the top of the columns and the
sales depts and info down the left labeling each row of data. See the
simplified example below.

Mon Tue Wed
Thur Fri Sat Sun Weekly Total
Food Sales
Bar Sales
Total Sales

Cash Deposit
Discover
Visa
Amex

Voids
House Charges

What you want is a multi-column report. Because you have fixed
columns which are not data points, a cross-tab isn't the answer. I
just needed the exact same thing and found it here:

http://support.microsoft.com/default...44&Product=acc

It show how to create a multi-column report and how (with some code)
to get the labels to show up only in the left column, and how to not
move to the next report record when those labels are printed
(Me.NextRecord = False).

That should do it.
David

Nov 17 '07 #3

Similar topics

vertical alignment of image

by: abracad | last post by:

Hi Is it possible to vertically align an image in the middle of a DIV of fixed height?

HTML / CSS

Vertical and horizontal centre with background

by: RickSure | last post by:

I am a new convert to css positioning and my second project is proving a challenge. Please help me from going back to tables! I found some code that created a vertical and horizontal result that...

HTML / CSS

XHTML/CSS Standard Vertical Centering sought

by: Kenneth | last post by:

Okay, I've been scouring Google for hours looking for a solution to this problem, but as of yet I can't find one. XHTML Transitional seems to specify that I can no longer set a table's height to...

HTML / CSS

Vertical labels on forms are invisible

by: PaulB | last post by:

In my application, I have many forms. Some of these forms contains some labels, which are placed in the header section, and act as a column header. Because of the available space, the orientation...

Microsoft Access / VBA

Report, reduce the vertical distances

by: tienlx | last post by:

Hi, I've a report (ReportAppointment.rdlc) in ASP.NET When viewing reports, the vertical distance between the two group are too big. I've tried to reduce the vertical distances but i can't. Demo:...

.NET Framework

vertical align with not specified height

by: acunnon | last post by:

I am trying to put together an login page my problem is getting the three items aligned to the middle verticaly without specifing a height to anything on the page. CSS html{ height:100%;...

HTML / CSS

Centering Both a Background Layer and Text Layers in css

by: ayamopamo | last post by:

Hi- I am trying to center a web page. It seems like this should be very simple to do, but apparently it isn't my day. I have successfully centered the background by calling it in the css body tag:...

HTML / CSS

glitch with vertical text in report print preview?

by: n8kindt | last post by:

i have a thread posted elsewhere but it got long and messy. this is all that needs to be seen: http://i3.photobucket.com/albums/y72/n8kindt/verticalerror2-1.jpg the report looks great until i...

Microsoft Access / VBA

vertical-align...

by: maya | last post by:

hi, how do I get text to vertical-align inside a div? http://www.mayacove.com/misc/home.html vertical-align should work, according to this:...

HTML / CSS

vertical line between snaking columns in ms access reports

by: appmab | last post by:

In Access 2003 I have a multi-column report (3 columns). I would like to get 1 continuous vertical line from the top of the page to the bottom of the page, between columns 1 and 2 and between...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General