Crosstab Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone
I'd like to make a report like this one :

Jan Feb Mar Apr ... and so on
Qt 15 25 30 28
Sale 3000 4500 6000 5800
Quota 2500 3500 5800 6500

This is about making several head columns instead of always one, and only one.
Any ideas please?
Tks in advance
Pedro
 
Hi Pedro,

make a Crosstab query for each of your lines. In your report, use
subreports based on each crosstab


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Hey Crystal
Tks a lot for your answer. I'm not very good on access, codes or
programming, that's why i think your idea is great. I'll try it cose i do it
with forms. But. Can i do, for example, the two crosstab qry i need, and
then, another crosstab qry to select all fields from the 2 crosstab query
and do a report with it? Any future complications? Tks in advance.
Pedro
 
One way is to use three crosstab queries.
Then in a union query combine like this ---
SELECT X, Jan, Feb, Mar, Apr, ... Dec, Null AS X1, Null AS Jan1,
Null AS Feb1, Null AS Mar1, Null AS Apr1, ... Null AS Dec2
FROM Crosstab1
UNION ALL SELECT Null AS X, Null, Null, Null, Null, ... X AS X1, Jan AS
Jan1, Feb AS Feb1, Mar AS Mar1, Apr AS Apr1, ...Dec AS Dec1, ... Null
AS Dec2
FROM Crosstab2
UNION ALL SELECT Null AS X, Null, Null, Null, Null, ... Null AS x, Jan
AS Jan1, Feb AS Feb1, Mar AS Mar1, Apr AS Apr1, ...Dec AS Dec2.
FROM Crosstab3;

Then use a totals query to roll it into a single row. You then have 39
fields for the report.
 
Hi Pedro,

you, you should be able to do that as long as Access doesn't complain
about things being too complicated.

I will caution you ... if you use a crosstab in the source for a
subreport (or subform), do not use LinkMasterFields and
LinklChildFields; set the filter yourself...

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top