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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF returning text value 6
Grouping Like Dates 2
Reports are only totaling the fields for the first record 2
Average multiple colums 5
Calculate statistical median of multiple fields in a query 1
parameter query 1
Query gives wrong output 3
Union Query 0

Back
Top