Merging the Outputs of Queries

  • Thread starter Thread starter RFJ
  • Start date Start date
R

RFJ

I have four queries, each of which produces a single specific numerical
answer (statistics). Let's call the queries Q1 Q2 Q3 Q4.

I want to pull those answers together (ideally into another query) where the
first field would be the query name (Q1-4) and the second field would be the
answer to each query.

Can it be done and, if so, can SKS, tell me how

TIA

Rob
 
Tx Chris. As a relative newbie to Access I hadn't come across the union
query - works like a dream <BG>
 
Back
Top