vertical reports

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

Re: vertical reports

On Tue, 06 Nov 2007 03:35:15 -0000, KitesLive
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

Re: vertical reports

Tom van Stiphout wrote:

> On Tue, 06 Nov 2007 03:35:15 -0000, KitesLive
> wrote:
>
> Check out "crosstab queries". There also is a query wizard to create
> them.
>
> -Tom.
>

Last week there was a thread titled "Technical Paper: Creating Monthly
Summary Reports without Code". It's body was...

"I just published a paper with a sample database describing how to
create a monthly summary report without VBA code. Basically, a
financial crosstab showing 12 months of summaries across the report.
http://www.fmsinc.com/tpapers/access/Reports/monthly/index.h tml

Hope this is helpful. I welcome any feedback on it. Thanks.

Luke Chung
President
FMS, Inc."

This is an excellent example of creating a report similar to what you
want that gets the report headings using a generic method the way you
want when using a crosstab.

>
>
>>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

Re: vertical reports

On Nov 5, 9:35 pm, KitesLive wrote:
> 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.aspx?scid=kb;en-us;2100 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