Can Access do this or do I need cyrstal reports?

[Dan V.]

I am trying to show things with a cross-tab query but with additional
headers.
Is that possible?

I would like to combine the idea of report 1 but with multiple values per
quarter as shown in Report2

Report 1:

UserID total | Q1 | Q2 | Q3 | Q4
-----------------------------------------------
User1
User2
....

Report 2
UserID total | Q1 | Q2 |etc.
| Value1| Value2 | Value1| Value2 | etc.

 

[Dan V.]

I am trying to show things with a cross-tab query but with additional
headers.
Is that possible?

I would like to combine the idea of report 1 but with multiple values per
quarter as shown in Report2

Report 1:

UserID total | Q1 | Q2 | Q3 | Q4
-----------------------------------------------
User1
User2
...

Report 2
UserID total | Q1 | Q2 |etc.
| Value1| Value2 | Value1| Value2 | etc.

It looks like I can do this but (visually speaking: not across the top
header as in left to right but in the left-most column going down'. You can
have multiple 'row headings' as they are called in the MS access cross-tab
design view, but they are actually go 'up and down' along in the left-most
column, just make sure group by is set on the additional 'row heading'.

 

[Guest]

Hi Dan,

Actually, you can do what you want without using additional row headings.
You might want to download a copy of the sample queries database from
Microsoft:

The "Access 2000 sample: query topics" database available in Download Center
http://support.microsoft.com/?id=207626

This sample applies to later versions of Access as well. For Access 97, use
this link instead: http://support.microsoft.com/?id=182568

The third topic in this sample (Access 2000 version) reads "How to Create a
Crosstab Query with Multiple Value Fields", and it references the following
KB article:

http://support.microsoft.com/kb/q209143/


Good Luck,
Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________


:

I am trying to show things with a cross-tab query but with additional
headers.
Is that possible?

I would like to combine the idea of report 1 but with multiple values per
quarter as shown in Report2

Report 1:

UserID total | Q1 | Q2 | Q3 | Q4
-----------------------------------------------
User1
User2
...

Report 2
UserID total | Q1 | Q2 |etc.
| Value1| Value2 | Value1| Value2 | etc.

It looks like I can do this but (visually speaking: not across the top
header as in left to right but in the left-most column going down'. You can
have multiple 'row headings' as they are called in the MS access cross-tab
design view, but they are actually go 'up and down' along in the left-most
column, just make sure group by is set on the additional 'row heading'.