We help IT Professionals succeed at work.

How to combine crosstab queries?

Anthony6890
Anthony6890 asked
on
Medium Priority
462 Views
Last Modified: 2012-05-11
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
Comment
Watch Question

LucasMS Dynamics Developer
CERTIFIED EXPERT

Commented:
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.

Author

Commented:
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...
MS Dynamics Developer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
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.  

Author

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.