Combine two query into one

luzz

Registered User.
Local time
Today, 12:15
Joined
Aug 23, 2017
Messages
346
Hi all, I would like to ask how to combine two different query into one?

I have a union query and I would like to combine it with another query.
I have attached images of the two query above.

The purpose of combining these two queries is to use it in creating a report.
The end result i hope to achieve with this query should include the fabrication, remarks together with the union query.
 

Attachments

  • Union Query.png
    Union Query.png
    57.6 KB · Views: 87
  • SecondQuery.png
    SecondQuery.png
    81.3 KB · Views: 87
What do you want the result to look like?

I want the result to have two column heading called Fabrication, Remarks. Then the size should match to the correct fabrication and remarks
 
Taking the data in the two pictures, please put it together so we can see what the desired output looks like. Your description is too cryptic.
 
Taking the data in the two pictures, please put it together so we can see what the desired output looks like. Your description is too cryptic.

Ok, I have attached an image of my desired output.
 

Attachments

  • endresult.png
    endresult.png
    10 KB · Views: 80

Users who are viewing this thread

Back
Top Bottom