asked on

How to combine crosstab queries?

I need to combine 4 cross tab queries in access into one.

My tables have a common row heading: MBFTPT but the heading changes to represent four different stores. Does anyone know how I can do this? I basically want it to look like this:

MBFTPT S&S PMK SR
F 60 120 72
P 42 10 62

Lucas

You can do one of 2 things:

1. Dump ALL your data into one table, then do your crosstab from there

OR

2. Go into your query design, and bring up the properties. There is a property called "column headings". Type in the headings that you want, and it should display them even if the values are null.

Anthony

ASKER

Hey thanks for getting back to me.

I don't know if I really want to dump all my data into a table and do a crosstab from there.

When you say to go to my query design, which query are you referring to? Right now I have the 4 separate queries, nothing has been combined yet...

ASKER CERTIFIED SOLUTION

Lucas

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Anthony

ASKER

What I ended up doing was using a union query to combine all the cross tab queries. I then input a line of code to sum across the row and create a totals column.

Thanks for your help.

Anthony

ASKER

The solution only offered one part of the problem. I needed to add a lot more to get the answer to do what I needed it to do.