Microsoft Access 2010: How to Create a Query which Combines Two Crosstab Queries under a Split, Merged Column

Sorry if the title is a little confusing. I am attempting to create a query which takes two crosstab queries and combines them in a slightly different format than the original crosstabs. I have used a simple union, but this just stacks the results on top of each other.

The goal is two combine a crosstab with lab results and a crosstab with a lab qualifier, so that under each sampling location header there are two columns (one column which pulls the result and one column which pulls the lab qualifier).

I have attached a picture of what the final query should produce. Under my current design the problems arise from merging the top two rows to create a "split, column" under each sampling location.

Original Format of Crosstab

Design of New Output Query (i.e. cells D3 and E3 would pull the result and lab qualifier from a crosstab in the original format above)

Open to any suggestions on how to accomplish this. Thanks!

Recent Questions...