question on cross tab queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LisaK - 14 Feb 2006 20:03 GMT

I am trying to take an excel spreadsheet and create a cross tab report just
like this. Here is what the excel spreadsheet looks like. Does anyone have
any suggestions on how I can duplicate the look of this?

    Oct 05        Nov 05        Dec 05
Review
Reason    C170 RC85 C170 RC85 C170 RC85

BAIR    147    1    115    1    99    3
BDMS    5    2    7    2    9    6
BFED    6    3        3        9
BNRU     6            5

I have created a crosstab report in Access, I just don't know how to get the
2 reports to list side by side.

Thanks

Reply to this Message

Duane Hookom - 15 Feb 2006 01:08 GMT

It is more than just a little difficult to see what your data looks like or
for that matter what you are asking. We don't know anything about your table
structure or data or crosstab SQL view...

You can place two reports in a main report as subreports.

Signature

Duane Hookom
MS Access MVP

>I am trying to take an excel spreadsheet and create a cross tab report just
> like this. Here is what the excel spreadsheet looks like. Does anyone
[quoted text clipped - 15 lines]
>
> Thanks

Reply to this Message